Running a T-SQL script under different credentials using SQLCMD.exe utility

Question

I created a batch file and placed the following line into it:

runas /user:internal\c39293 "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -E -S WLDZ9454 -d ChadDb -Q "usp_Test"

I was trying to run the stored procedure usp_Test on the server WLDZ9454 against the ChadDb database.

When I execute it, I just get info regarding param options, no error mesage, so it isn't clear to me what I am doing wrong.

Note that when I run the code minus the code that attempts to run under different credentials, it works:

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -E -S WLDZ9454 -d ChadDb -Q "usp_Test"

Chris Diver · Accepted Answer · 2011-05-09 12:10:23Z

3

I suspect it's because you have not enclosed the program you are running and its parameters in quotes.

SqlCmd is therefore executed without any parameters.

 runas /user:internal\c39293 """C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"" -E -S WLDZ9454 -d ChadDb -Q ""usp_Test"""

answered May 9, 2011 at 12:10

Chris Diver

19.9k4 gold badges50 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chad Over a year ago

Close. This did it: runas /user:internal\c39293 "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE -E -S WLDZ9454 -d ChadDb -Q "usp_Test"". thanks.

Collectives™ on Stack Overflow

Running a T-SQL script under different credentials using SQLCMD.exe utility

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related