The users will only get access to a datawarhouse not on the production db.

But thanks for the info.

rgds

Hi,

Would it work if I setup a job to trigger the stored procedure and then start the job from my outer sp as regular user?

Serge

On may local workstation.

this command :

DECLARE @cmd VARCHAR(255)

SET @cmd = 'osql -E /Q "SELECT GETDATE()" /o \\AS-B-CLI-000\c:\temp\test2.csv'

EXEC master..xp_cmdshell @cmd

will generate error:

output

Cannot open output file - \\AS-B-CLI-000\c:\temp\test2.csv

No such...

Is there a way to simulate the "query analyzer" result options where you can choose to have the result send to a file. This way i d'ont need to tamper with...