Difference between sp_who and sp_who2

The sp_who and sp_who2 both commands purpose is same.But the difference is,

sp_who supports the limited columns information about currently running process in the SQL Server.

sp_who2 supports some extra columns information about currently running process in the SQL Server then sp_who command.

sp_who command is documented and officially supported by the Microsoft.

sp_who2 command is undocumented and don’t have any support from Microsoft.

But mostly uses sp_who2 command for better information of the running process.

The following images show the clear information about  sp_who and sp_who2.

sp_who

sp_who

sp_who2

sp_who2

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s