StumbleUpon
Share on Facebook

Tuesday, April 24, 2007

Monitoring SQL SErver with SP_WHO

MONITORING SQL SERVER WITH SP_WHO

Exec sp_who

will provide information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine

Use the login to filter results for a particular user
Exec sp_who 'Login21'


No comments:

Related Posts Plugin for WordPress, Blogger...