Msg 11519, Level 16, State 1, Server, Procedure sp_describe_first ...
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 …
Check Stored Procedure is Running or Not
Nov 20, 2012 · 1. Use SQL Profiler tracing Stored Procedures 2. execute sp_who2 to get the list of connections
Invalid locator de-referenced - social.msdn.microsoft.com
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 …
blocking_session_id question - social.msdn.microsoft.com
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 …
Get dbid from sys.dm_exec_sql_text for ad hoc sql?
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.
Error Retriving Backup Filelistonly - social.msdn.microsoft.com
SELECT @Sql = 'RESTORE FILELISTONLY FROM DISK=''' + @FileName + '''' INSERT INTO #BackupFileData EXEC (@SQL) -- Grab the Logical backup names from the work table …
Cannot process the object "exec DBNAME.dbo.usp_TEST". The OLE …
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 …
BCP Connection Error: SQLState = 28000, NativeError = 18456
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 …
Dynamically Create table and insert the records from source to ...
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 …
Why isn't Resource Governor working as expected?
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 …