I want to use this procedure to move some files around within a ASP application. Do anyone have experience of using these and is there likely to be any problems?

Thanks

Steve

Can you be more specific on the task that you like to accomplish or post sample

Jaime E. Maccou
Applications Analyst

Basically I want to copy one folder from c:\ to c:\test.

This works fine but before I use this in a production environment I wanted to be sure there were no problem with this approach.

you should have no problems using xp_cmdshell but keep in mind that you should not grant users who do not have admin privileges to use this extended procedure. Using and having such privileges allows you do execute any (DOS) command on your servers OS.  

EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps',
   NO_OUTPUT

You may also want to check out BCP


Jaime E. Maccou
Applications Analyst