Which user account is running SQLCMD in T-SQL Script without -U and -P option?
Posted
by niteshg
on Stack Overflow
See other posts from Stack Overflow
or by niteshg
Published on 2010-03-19T10:37:57Z
Indexed on
2010/03/19
10:41 UTC
Read the original article
Hit count: 236
I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder.
Could you please help me under which account sqlcmd will run if I do not specify -U and -P option in TSQL Script?
© Stack Overflow or respective owner