Difference Between sp_who & sp_who2
Purpose of sp_who and sp_who2 is same.But some key differences are:
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.
sp_who2 is more widely used for better information of the running process.
The following images show the clear information about sp_who and sp_who2.
sp_who
sp_who2
