t-sql

SQL SERVER %26ndash; Recently Executed t-sql Query
About a year ago, I wrote blog post about SQL SERVER %26ndash; 2005 %26ndash; Last Ran Query %26ndash; Recently Ran Query .� Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please refer to following update query to recently executed t-sql query on database. SELECT deqs.last_execution_time AS [Time] , dest. TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APP

Blog Content