thank you this is what I am looking for, appreciate for all responses

Here I am actully looking to copy my .bak file to a network drive once the backup was done, I want use xp_cmdshell to copy the files

Greg, after logging ON, where exactly i need to find the Log to look for error in sql server.

The Job execute the DTS package on daily basis, it failed with Process EXit code 1

/***Find Current Location of Data and Log File of All the Database***/

SELECT name, physical_name AS current_file_location

FROM sys.master_files

nothing has been changed in the code, we were using a third party tool Tidal-scheduler to automate this job. The automate job was failing with the error I have given....

The job was running till Dec16 2009, it was started failing from dec 17th. pls help wht is causing the problem.

Can somebody pls findout why is this job failing?

----------------------------------SP3

USE [DATABASE]

GO

/****** Object: StoredProcedure [dbo].[sp_ChangeReportProcessField] Script Date: 12/18/2009 15:28:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE Proc [dbo].[sp_ChangeReportProcessField](

@ClientVarChar(4),

@SeqNumint,

@FieldNameVarChar(50),

@ChangedFieldNameVarChar(50)

) as

Declare @UpdateText as VarChar(2000)

Set @UpdateText =

'Update GeStatus '...

I dont have anything to test them..

NO, these SP are depend on the Main SP.

Main stored procedure is using cursor to check all the clients update with the new records.

After getting the new records, i think it is failing while updating.

--New Record, everythings changed(PART OF OTHER STORED PROCEDURE)

UPDATE GeStatus

...

Declare @UpdateText as VarChar(2000)

Set @UpdateText =

'Update GeStatus ' +

'Set ChangedRecordX = ''x'', ' +

'[' + RTrim(@ChangedFieldName) +'] = ''x'' ' +

'Where Client = ''' + RTrim(@Client) + ''' '...

sql server Error: 50000, is found in sql server agent Error log.