Check the SMTP server. There are security settings concerning 'forwarding'. The SQL Server that you are performing the send from is probably not defined there.

We had a 160 Gb database that was backed up through a maintenance plan and it executed in 65 minutes. We have since modified the the backup into 'stripes' (4 .BAK files...

Granted there are ways to restrict things, however this realy seems like a thing for the contract people (lawyers) at your firm.  A simple acronym - NDA (non-disclosure agreement). If your...

You may want to include full drive/directory or UNC naming on all files in your scripts that are executed via xp_cmdshell. I believe the 'default' directory for xp_cmdshell execution is:...

Could you post the source of the SP ?

Another thought is to script out the JOB, delete it then add it back. I've had this happen once or twice and that did the trick.

From BOL:

ALTER DATABASE database_name

MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).

Triggers or columns hmmm ... there is no 'right or 'NO WAY' (wrong answer) ... it all depends ... if the system is OLTP, with low volume (<100 transactions minute),...

WHat is your database recovery mode ? Are you executing a maintenace plan against the database ?

I do not have any answers to your questions but a point to look out for - disk defragmentation software may be an issue if you deviate from the default...

The file is a .chm, and it needs IE. I did have an issue with it running from a network drive after Win 2K3 Server SP1 was applied so I...

You should download the file to your local PC then launch it.

Here's a reference on SQL 2000 databases no DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

This may answer a great deal of your questions when used in conjunction with BOL.

I'd prefer Ray M's first option:

Select Case when charindex(',',Artist) = 0 then Artist else left(artist,charindex(',',artist)) end

Why muddy things up with a union ...

Could you post the DDL for the table ? It may shed a trmendous amount of light on the issue.