Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2010-10-19 : 10:09:19
|
| Hi allI am not a DBA or a system engineer, but I need some tool (queries, etc.) that allow me to monitor what is happening in a SQL Server 2000 database.Especially my .NET application lock and often find that they send timeout in exception to the application itself, and I need some t-SQL script to figure out which table is locked, by whom, how long, etc. and all information that may be useful.Has anyone ideas?Thanks in advance. Luigi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
[SS 2000] Checking locks