SyntaxFix

[sql] How to enable Ad Hoc Distributed Queries

You may check the following command

sp_configure 'show advanced options', 1;
RECONFIGURE;
GO  --Added        
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO

SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',
     'SELECT GroupName, Name, DepartmentID
      FROM AdventureWorks2012.HumanResources.Department
      ORDER BY GroupName, Name') AS a;
GO

Or this documentation link

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server-2008

• Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object • How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned • SQL Server : How to test if a string has only digit characters • Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query • Get last 30 day records from today date in SQL Server • How to subtract 30 days from the current date using SQL Server • Calculate time difference in minutes in SQL Server • SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904) • SQL Server Service not available in service list after installation of SQL Server Management Studio • How to delete large data of table in SQL without log?