tag:blogger.com,1999:blog-2328222207349876984.post1921746319148297305..comments2024-03-02T15:36:45.785-08:00Comments on SQL Tact: Using sys.dm_exec_requests to find a blocking chain and much moreUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2328222207349876984.post-5242354654288789642014-12-16T08:45:14.336-08:002014-12-16T08:45:14.336-08:00Thanks for the post - very helpful!Thanks for the post - very helpful!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2328222207349876984.post-40658717309406271132014-09-17T07:47:08.155-07:002014-09-17T07:47:08.155-07:00Anonymous-
Look out for SQL 2000 compatibility dat...Anonymous-<br />Look out for SQL 2000 compatibility databases or SQL 2000 instances. I can reproduce your error only by running the script in the context of a database in SQL database in Compatibility Level 80.<br />This script, like any script that uses a DMV, won't work for SQL 2000.whttps://www.blogger.com/profile/04313158818403554742noreply@blogger.comtag:blogger.com,1999:blog-2328222207349876984.post-34424265328009086472014-09-17T06:16:18.872-07:002014-09-17T06:16:18.872-07:00Msg 102, Level 15, State 1, Line 101
Incorrect syn...Msg 102, Level 15, State 1, Line 101<br />Incorrect syntax near '.'.Anonymousnoreply@blogger.com