SQLServer add linked server

No details none -- enable AdHocDistributedQueries: execsp_configureshowadvancedoptions, exceptions, 1reconfigure -- disable AdHocDistributedQueries: execsp_configureAdHocDistributedQue

No details none -- enable Ad Hoc Distributed Queries: exec sp_configure 'show advanced options', 1 reconfigure exec sp_configure 'ad Hoc Distributed Queries ', 1 reconfigure -- disable Ad Hoc Distributed Queries: exec sp_configure 'ad Hoc Distributed Que

<无详细内容> <无>

-- Enable Ad Hoc Distributed Queries: exec sp_configure 'show advanced options', 1 reconfigure exec sp_configure 'ad Hoc Distributed Queries ', 1 reconfigure -- disable Ad Hoc Distributed Queries: exec sp_configure 'ad Hoc Distributed Queries ', 0 reconfigure exec sp_configure 'show advanced options', 0 reconfigure -- add the exec sp_addmediaserver' Server Service name', ', 'sqloledb ', 'server service name' -- add the login exec sp_addjavassrvlogin 'server service name', 'false', null, 'sa ', 'Password' --- start the Stored Procedure exec sp_serveroption 'server service name', 'rpc out', 'true' -- delete the service and log on to exec sp_dropserver 'server service name ', 'droplogins' Select * From sys. serversSelect top 1 * From [server service name]. [master]. sys. databases