What are the possible disadvantages of enabling distributed queries on SQL Server 2005?

Posted by Corp. Hicks on Server Fault See other posts from Server Fault or by Corp. Hicks
Published on 2010-05-27T12:23:57Z Indexed on 2010/05/27 12:33 UTC
Read the original article Hit count: 101

We plan to change the default server options of an SQL2k5 server instance by enabling distributed queries.

The reason is that we want to run "SELECT * FROM OPENQUERY(LOCALSERVER, '...')" -like statements on the server.

What are the possible disadvantages of enabling distributed queries?

(There must be a reason for MS setting this option to disabled by default...)

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2005