Monday, March 26, 2012

How delete or rename file in storedprocedure

I want to rename or delete a file in my storedprocedure.
how?
TarvirdiYou can use xp_cmdshell, assuming you understand the permission implications.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tarvirdi" <m_tarvirdi@.isc.iranet.net> wrote in message
news:ObmPN62YGHA.2208@.TK2MSFTNGP03.phx.gbl...
>I want to rename or delete a file in my storedprocedure.
> how?
> Tarvirdi
>|||U should have permission to execute xp_cmdshell.
U should have configured sql server to enable services for xp_cmdshell.
u can configure xp_cmdshell from sp_configure option.
HTH
from
Dollersql

No comments:

Post a Comment