Hi there:

I have a script that uses xp_cmdshell to copy over a database backup file.  I'd like to be able to have a stored procedure (email notification of error) called if either "The network path was not found" or "the system cannot find the file specified'.  These were both error messages returned by sql when testing around with bogus locations.

Here's the sql:
 

xp_cmdshell 'COPY \\server1\backup$\PA880PRD_Full_LiteSpeed.BAK\\server2\backup$\PA880PRD_Full_LiteSpeed.BAK'


Appreciate insight

You can create a table and dump the results from xp_cmdshell into that and then p*** the messages. Essentially you would create a table like this:

DECLARE @Return INT ;
CREATE TABLE #Errors ([Results] NVARCHAR(1000)) ;

And then do an Insert Into EXEC similar to this:

INSERT INTO #Errors ([Results])
EXEC @Return = master..xp_cmdshell 'Your cmd script here' ;

And also check the return (@Return) value as well.

Great, thanks for this.  It did the trick!