sys.dm_exec_sql_text

  • 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, 

  • 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.

  • 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,

  • 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