Hi,
I have created a stored procedure which runs uses master..xp_cmdshell @filename

This SP basically transfers a file from the network onto my pc.
When this sp is run in the quesry analyser, it works fine but not in ASP.NET
As soon as it hits the ExecuteNoNQuery then it says that there is a severe error.
I believe this is to do with permissioning??
The anonymous access is unchecked.
Do you know what can be done to run this sp in ASP.NET please?
Thanks