Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ken Simmons Return Query Text Along With sp_who2 Using Dynamic Management Views RE: Return Query Text Along With sp_who2 Using Dynamic Management Views

  • June 26, 2008 at 7:29 am

    #834633

    sheetalsh (6/26/2008)

    Hi Ken,

    It's giving error as follows:

    Msg 321, Level 15, State 1, Line 28

    "sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.

    Thanks,

    SS

    Right Click on your database and select properties. Under the options tab the compatibility level has to be set to "SQL Server 2005 (90)" for it to work.