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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-04-02 : 00:58:31
|
| Dear All,i've a doubt regarding the difference between sp_who and sp_who2.i've read in one article stating that sp_who is documented and sp_who2 is un documented.what is meant by this?and please provide me the articles related to locks(what are different types of locks)thank you very muchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-04-02 : 01:48:01
|
| For different types of locks:http://www.vikramlakhotia.com/Different_Types_of_Lock_in_SQL_Server.aspxJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-04-02 : 04:36:04
|
| thank you for the link provided....with the command dbcc opentran, i can find the lock and i can kill the SPID.but how coluld i know which type of lock is that?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 23:30:04
|
| You can find it out with sp_locks. |
|
|
|
chetan_dba
Starting Member
21 Posts |
Posted - 2008-04-03 : 02:43:55
|
| One more thing i would like to add here for the difference between sp_who and sp_who2sp_who2 gives user more comprehensive data. The columns shown in the sp_who2 command are :SPID, Status, Login, HostName, BlkBy, DBName, Command, CPUTime, DiskIO, LastBatch, ProgramName, SPID, REQUESTID.Thanks in advance.-- Chetan |
|
|
|
|
|
|
|
|
difference between sp_who and sp_who2