CODEWITHSUNDEEP
sql-serversql-server-2000
user1063108
user1063108

Reputation: 712

is there a possibility to run sys.dm_exec_sql_text in sql server 2000

Does any know if this query can be converted and run in sql 2000

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.TEXT like '%sp_OACreate%'
ORDER BY deqs.last_execution_time DESC

Thanks

Upvotes: 3

Views: 3739

Answers (1)

Devart
Devart

Reputation: 122002

Possibly this be helpful for you -

SELECT 
      spid
    , login_time
    , last_batch
    , [status]
    , loginame
    , [db_name] = DB_NAME([dbid])
    , (SELECT [text] FROM ::fn_get_sql(sp.[sql_handle])) Command 
FROM [master].dbo.sysprocesses sp 
WHERE spid = @@SPID

Upvotes: 2

Related Questions