KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to check the exit status (success/failure) of a query run through SQLCMD utility. For example, the server I am connecting doesn't have a database name EastWind . Then, the command below fails with the message ... > "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -S ZEPHIR -E -Q "USE WestWind" Changed database context to 'WestWind'. > echo %errorlevel% 0 > "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -S ZEPHIR -E -Q "USE EastWind" Database 'EastWind' does not exist. Make sure that the name is entered correctly > echo %errorlevel% 0 I see that the return value is the same in both the cases. How can I check if a command has failed in SQLCMD ?
Tags (comma-separated)
Save Edits
Cancel