May 23, 2006 at 5:16 pm
Hello Everyone
I have a stored procedure that spools out a text file based on a sql table name, so for example if the tablename is called test, I can then spool out a table called test.txt with a custom delimeter.
The SP makes use of the sa password, but now that we have now moved onto windows authentication, is there anything that I can do ? Or perhaps has anyone got any code to do the same ?
Any help would be appreciated.
Thanks
May 24, 2006 at 1:58 am
I trust the password is not embedded in the proc?
Your question indicates a lack of some understanding of sql server but I assume the proc calls isql, osql, dtsrun or some such - you need to change the account details ( connection string ??? ) to use integrated security ( trusted ) and make sure the caller ( of the proc ) has sufficient permissions.
Bit tricky without a better idea of the code involved.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply