sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

What, When, Where, How, Who2

Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address

usp_SQL_In_sp_who2

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID

Indepth SPID information

This SP gives you most of the detail you need on a long running query. Simply pass the SPID.

Unable to create Publication

Hello,I am having a strange problem. I am unable to create ANY new publication on any of the databases. I try to add it using the SQL Enterprise Manager or Query Analyzer and get the following error for exec sp_addpublication :Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24 Supply either @job_id or @job_name […]

RE: Why Generic Error Handling?

Is this the same question as on SQL Server Performance.com?http://www.sommarskog.se/error-handling-II.htmlhttp://www.sommarskog.se/error-handling-I.htmloffer a good insight on error handling.

RE: SQL Server Restore

Hi again... Now it'sServer: Msg 3206, Level 16, State 1, Line 1 No entry in sysdevices for backup device 'f:\cp.bak'. Update sysdevices and rerun statement. Server: Msg 3013, Level 16, State 1, Line 1 VERIFY DATABASE is terminating abnormally.  The backup is NOT from that server... undestand ? 

RE: String Tokening

Not aware of a function, per se but you could try thisSELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0 THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1) ELSE [Input] END