Who can be able to help me below tow question？Thanks in advance! 1.the difference between sp_who and sp_who2? 2.how to find the final process which caused the deadlock ?
Use Enterprise Manager ... Go to Management > Current Activity. Here you have two views, "Locks / Process ID" and "Locks / Object". Just check the process IDs, and compare against the "Process Info" view. Have fun!
