What are the possible disadvantages of enabling distributed queries on SQL Server 2005?
- by Corp. Hicks
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...)