SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 difference between sp_who and sp_who2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sunsanvin
Flowing Fount of Yak Knowledge

India
1274 Posts

Posted - 04/02/2008 :  00:58:31  Show Profile  Send sunsanvin a Yahoo! Message  Reply with Quote
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 much

Vinod
Even you learn 1%, Learn it with 100% confidence.

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 04/02/2008 :  01:48:01  Show Profile  Visit jackv's Homepage  Reply with Quote
For different types of locks:http://www.vikramlakhotia.com/Different_Types_of_Lock_in_SQL_Server.aspx

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

sunsanvin
Flowing Fount of Yak Knowledge

India
1274 Posts

Posted - 04/02/2008 :  04:36:04  Show Profile  Send sunsanvin a Yahoo! Message  Reply with Quote
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?

Vinod
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/02/2008 :  23:30:04  Show Profile  Reply with Quote
You can find it out with sp_locks.
Go to Top of Page

chetan_dba
Starting Member

India
21 Posts

Posted - 04/03/2008 :  02:43:55  Show Profile  Reply with Quote
One more thing i would like to add here for the difference between sp_who and sp_who2
sp_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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000