redouard
asked on
Writing to a text file from a stored procedure
I created this script to output the results from a stored procedure to a text file. The file is not being created.
declare @cmd varchar(1000)
select @cmd = 'osql -S xxxx -d xx -Q"sp_help_revlogin2" -o"c:\osqloutput.txt" -w500'
exec master..xp_cmdshell @cmd
Perhaps you do not have the appropriate permissions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good point.