Aug 7, 2015 · The trick with SET FMTONLY OFF does not work when both servers are running SQL 2012 or later. And it never was a good idea. You need to add the clause WITH RESULT SETS to the …

Nov 20, 2012 · 1. Use SQL Profiler tracing Stored Procedures 2. execute sp_who2 to get the list of connections

Jan 31, 2007 · SQL_LEN_DATA_AT_EXEC (length), where length is the total length of the text, ntext, or image parameter data in bytes. So, you can call SQLPutData one or more times as long as the total …

May 12, 2016 · You would need to look in sys.dm_exec_sessions and related DMVs, yes. A session_id only appears in sys.dm_os_waiting_tasks only appears as session_id if the process is waiting.

Jun 3, 2012 · I am passing a sql_handle from sys.dm_exec_query_stats to sys.dm_exec_sql_text, to get the dbid, objectid and statement text.

SELECT @Sql = 'RESTORE FILELISTONLY FROM DISK=''' + @FileName + '''' INSERT INTO #BackupFileData EXEC (@SQL) -- Grab the Logical backup names from the work table SELECT …

Aug 23, 2011 · Cannot process the object "exec TeraQuery". The OLE DB provider "SQLNCLI10" for linked server "csparpsql002" indicates that either the object has no columns or the current user does …

Nov 19, 2009 · Go to the path C:\Program Files\Microsoft SQL Server\90\Tools\Binn and find bcp.exe application and right click and run as with your domain account and then specify -T in your command …

Even you can not use @TABLE directly in SELECT or INSERT statement. You need to create dynamic SQL string and execute it with EXEC command. Example, DECLARE @TABLENAME NVARCHAR …

Nov 7, 2016 · Based on my searching and testing, this is by design, Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption, in your scenario, …