Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Modified SP_who

By nagdimunovd,

Here is a modified SP_WHO procedure
which returns more information about the current session.
I forgot all the thing that i have added to the sproc, but the last addition shows the last executed TSQL statement.
There might be a better solution to get the values from DBCC rowset, thou I did not have time to think everything through.
If you think you have a better solution, let me know.
Thanks

Good Luck
Dan

Total article views: 644 | Views in the last 30 days: 3
 
 
Contribute