sql server new users: Designate an users database lock -- sql server new users

Designate an users database lock

Gunnar
12/20/2004 8:17:35 AM

sql server new users:

Dear Teammembers,

is there any posibility to designate which user causes a database lock?
Thanks in advice.
Gunnar

Re: Designate an users database lock

Cristian Lefter
12/20/2004 2:22:03 PM

1. sp_who
2. "Displaying Locking Information" Books Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_7a_0uni.asp
3. "How to monitor SQL Server 2000 blocking"
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
4. Use a trace "INF: How to Create a SQL Server 2000 Trace"
http://support.microsoft.com/default.aspx?scid=kb;en-us;283790

Other articles of interest:
1."INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking
Problems" http://support.microsoft.com/default.aspx?scid=kb;en-us;224453
- Cristian

[quoted text, click to view]