BR><BR>If I open SQL Management Studio and run a query on the server itself it works great ... just want to be sure I'm referencing these linked servers properly.

Is it possible to use linked services in MSSQL Server and execute queries if the ... is there any way to still use linked servers?<BR><BR>EDIT: I guess what I really mean is how can I use read ...

Select statements issued across linked servers will simply use two different ... are manually started as distributed transactions. SQL Server will automatically escalate transactions from normal ...

SetupAdmin: Any member can manage linked servers and SQL Server startup options and tasks. Security Admin: Any member can manage server security. ProcessAdmin: Any member can kill processes ...