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?

usp_who5

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

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  

RE: INSERT ... SELECT problem

Thank you very much.  Sometimes I miss the obvious!jmatt

Disappearing distribution job

I am copying all data from a production database to a development counterpart (both SQL Server 7) weekly by means of snapshot replication, but I am mystified by the repeated disappearance of the distribution job.  I use the Enterprise Manager wizard to create the push subscription on Friday, creating a distribution job in the SQL Server […]

RE: Database recovery

Hi James,what do you mean with the database is corrupted ? What error does it give. Can you access the database ?If the status of the database is loading, check your settings in BackupExec. I know that older versions did leave the database in that status in order to restore Tlog backups. If you don't […]

RE: Passing variables

Hi Lane,Please check the length of the datatype you have used in ur stored proc(sp). I assume u have used varchar as ur datatype. If u have not given any length than it will take the first character of the string that u have passed as a parameter to u r sp.by the way please […]