Thanks, alzdba. I was trying to use a Convert statement with concantenation to get the year and month into one column like '2004/1'. I guess that was the error of...

Thanks for your replies.

If you test this, put some non-numeric data in the PO field. On SQL 7, it won't report an error. On 2000, it reports an error. SQL...

Yes, I'm sure the stored procedure works in SQL 7. I tested it this morning.

And you are correct, if I change the 2nd parameter to the procedure to nvarchar,...

All better now. The problem with the SQLServerAgent service has to do with the mail profile. I removed the mail profile from the SQLAgent properties & SQL Mail properties, changed...

Thanks Steve, switching the service to a local admin account works.

Microsoft recommends using a domain account so that jobs can access other servers. Does a job use the SQLServerAgent...