xp_cmdshell

[nancyd1111]

Hi,

I am trying to erase a file using xp_cmdshell and my filename is stored in a variable. Can you tell me how I allow xp_cmdshell to interpret my filename instead of taking it as a literal?

Thanks in advaince!

-------------------------------------------------------

set @filename = N'\\AUTOPILOT\cdrive\Trace\Trace_' + @PlanName + '.trc'

Print @filename
exec master..xp_cmdshell 'erase @filename'

The message displayed is:
Could Not Find C:\WINDOWS\system32\@filename

 

[gmmastros]

Does this work???


exec master..xp_cmdshell 'erase ' + @filename


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[nancyd1111]

Nope. This is incorrect syntax neat '+'.

 

[gmmastros]

Seems like the xp_cmdshell is a little finicky. Try this...

set @filename    = N'\\AUTOPILOT\cdrive\Trace\Trace_' + @PlanName + '.trc'

[red]Declare @Command VarChar(1000)
Set @Command = 'Erase ' + @FileName[/red]
Print @filename
exec master..xp_cmdshell  [red]@Command[/red]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[nancyd1111]

Worked like a charm!

Thank You!

 

[gmmastros]

you're welcome.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom