How to enable Ad Hoc Distributed Queries

by

The following command may help you..

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Insert local .csv data in remote SQL Server via already working connection string
  3. Syntax combine two stored procedure into one [closed]
  4. How to delete duplicate rows in SQL Server?
  5. CROSS JOIN vs INNER JOIN in SQL
  6. How to cast the DateTime to Time
  7. How can I schedule a job to run a SQL query daily?
  8. Reset identity seed after deleting records in SQL Server
  9. How to avoid the “divide by zero” error in SQL?
  10. Multiple INSERT statements vs. single INSERT with multiple VALUES
  11. Real life example, when to use OUTER / CROSS APPLY in SQL
  12. Common Table Expression, why semicolon?
  13. T-SQL split string based on delimiter
  14. SQL Server 2008: how do I grant privileges to a username?
  15. How do I find duplicates across multiple columns?
  16. Generate script in SQL Server Management Studio
  17. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  18. How to get the size of a varchar[n] field in one SQL statement?
  19. Stored procedure that exports data into csv files only exports to one file
  20. SQL Server: should I use information_schema tables over sys tables?
  21. TSQL – How to use GO inside of a BEGIN .. END block?
  22. SQL take just the numeric values from a varchar
  23. Restrict varchar() column to specific values?
  24. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  25. Using CASE Statement inside IN Clause
  26. Single or multiple databases
  27. SQL Unpivot multiple columns Data
  28. Foreign Key Not Populating with Primary Key Values
  29. Connect different Windows User in SQL Server Management Studio (2005 or later)
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment