Enable 'Ad Hoc Distributed Queries' in SQL server

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 1225
Below is the code snippet to enable server/instance level configuration

sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

Comments or Responses

Login to post response