Table Locking Information??? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Table Locking Information???

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2005-11-10 : 05:58:36

Hello friends!!

Can any body please tell me... is there any way to find which table is locked currently....suppose my two or three jobs are running and at that same time will I check which table is currently locked...????

T.I.A

Papillon

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-10 : 06:07:10

See if these are helpful

1 Run the Profiler
2 run sp_who or sp_who2
3 http://vyaskn.tripod.com/sp_who3.htm
4 http://www.mindsdoor.net/SQLAdmin/sp_nrInfo.html

Madhivanan

Failing to plan is Planning to fail

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2005-11-10 : 07:02:37

Hi madhivanan!!
thanx for ur valuable time but what i exactly want to know is which table is going to lock during my job run process...here i am getting spid and processs.....u know what i mean.....do needful if...

T.I.A
Papillon

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources