handling file permission

[fmardani]

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

[rdove]

Fill in the SP and User you want to run the SP and execute in Query Analyzer. The [User] should be the User ID you are using in your connection string.

Grant Execute on [Stored Procedure] to [User]

[fmardani]

yes, I did do what you suggested and the error is still the same
A severe error occurred on the current command

:-(

[rdove]

http://support.microsoft.com/default...b;en-us;827366