Wednesday, March 21, 2012

rename a file without xp_cmdshell

Hi:

By default xp_cmdshell is disabled on new Installation of SQL Server 2005. I want to know how do I rename a file without using xp_cmdshell option?. What are my options programmatically to rename a file without using xp_cmdshell from T-SQL. One option is to create a Active x VB Script that uses the file system object to rename a file in a DTS package and then run the package.

Any ideas would be higly appreciated.

Thanks

Meher

you may use a CLR functions to achive such a requirement

No comments:

Post a Comment