Post reply

sys.dm_exec_sql_text

  • August 14, 2007 at 8:39 am

    #121035

    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

    #726815

    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

    #726850

    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

    #726860

    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