October 2008
Use this custom solution to check error logs in a mixed SQL Server 2005 and SQL Server 2000 environment.
SQL Server Magazine
March 2005
Sp_who and its cousin sp_who2 give DBAs crucial information about SQL Server user connections and processes, but they have limited filtering and block-finding capabilities. Welcome sp_who1, a new member of the sp_who family that tackles those limitations.
SQL Server Magazine