August 14, 2007 at 8:39 am
I am not able to use, or even find, (the dmv) sys.dm_exec_sql_text. Any ideas where I should look and what to do if it isn't there? Thanks in advance,
August 14, 2007 at 8:49 am
sys.dm_exec_sql_text is a system table-valued function. You can find it in the master database. Check BOL for how you can call it.
August 14, 2007 at 9:57 am
I can see a number of other objects of this nature, e.g., dm_exec_sessions, but not dm_exec_sql_text. Any ideas on how I can "get this"? Thanks,
August 14, 2007 at 10:29 am
Here:
Databases
master
Tables
Views
Synonyms
Programmability
Stored Procedures
Functions
System Functions
Table-Valued Functions
And this is the Help url: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/61b8ad6a-bf80-490c-92db-58dfdff22a24.htm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply