Comments on Keep It Simple and Fast: What is the syntax of the query which is locking d...

Thanks Mark for the info about this on SQL 2000. I...

2009-09-30T21:33:15.889+02:00

Thanks Mark for the info about this on SQL 2000. I have updated my blog.

I have found that SQL 2000 can support this after ...

2009-09-25T11:32:27.244+02:00

I have found that SQL 2000 can support this after applying a hotfix. Then the information is available.

http://support.microsoft.com/kb/325607

Greetings Mark

Mark, Thanks for your question. There is not a si...

2009-09-07T15:25:41.337+02:00

Mark,

Thanks for your question. There is not a similar script for SQL 2000 becuase SQL2000 is not storing such information.
Gr. André

It seems this script only runs vor 2005 and higher...

2009-09-07T13:58:49.619+02:00

It seems this script only runs vor 2005 and higher as it gives errors when ran on compatibility level 80 and runs on 90. Do you have a similar script for 80/SQL 2000?

Kind regards,

Mark