Actually with SQL Server 2005 express the job agents functionality has been disabled.

My question is how do I backup a database(The process)?

Thank you Russel Loski,

That worked perfect!!

thanks,

Dean

Thank you John,

That worked perfect!!

Dean

How would you set RECURSIVE_TRIGGERS off?

Will this be an issue if I am within a Transaction?

it can be but looking for this type of solution for other reasons.

Is there a way of having the trigger some how use the Instead of command to handle not...

This is a field/column in the same table called Modified_Date

AJ Ahrens

Remi Gregoire

Your last queries worked great!

thanks,

Dean

Perfect, thanks!!

The final Solution that works is:

CREATE PROCEDURE MoveFile(@FileName1 varchar(255), @FileName2 varchar(255)) AS

Declare @cmd varchar(2000)

Set @cmd = 'move '+@FileName1+' '+@FileName2

exec master..xp_cmdshell @cmd

GO

ok,

CREATE PROCEDURE DeanTest(@FileName1 varchar(255), @FileName2 varchar(255)) AS

Declare @cmd varchar(2000)

Select @cmd = 'move \\netservice2\public\Dean\Junge\DeanTest.txt \\netservice2\public\Dean\Junge\DeanTest.process'

Print @cmd

SELECT @cmd = 'master..xp_cmdshell ' + '''' + @cmd + ''''

Print @cmd

--exec master..xp_cmdshell 'move \\netservice2\public\Dean\Junge\DeanTest.txt...

Stored procedure using xp_cmdshell:

CREATE PROCEDURE DeanTest(@FileName1 varchar(255), @FileName2 varchar(255)) AS

Declare @cmd varchar(2000)

Select @cmd = 'move \\netservice2\public\Dean\Junge\DeanTest.txt \\netservice2\public\Dean\Junge\DeanTest.process'

Print @cmd

SELECT @cmd = 'master..xp_cmdshell ' + '''' + @cmd + ''

Print @cmd

Exec @cmd

GO

Here...

I am talking about an actual text file

ok, Now I get a new error, when running the job agent, please note this is a DBF file I am trying to load:

Executed as user: \. DTSRun: Loading......