SqlCmd and ":Error" ability in the command line - by LoudRock

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 543685 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/22/2010 6:22:37 AM
Access Restriction Public



//Quote From Above URL
sqlcmd Commands

In addition to Transact-SQL statements within sqlcmd, the following commands are also available:
//End Quote

In regards to the ":Error" command (inside the .sql script), there is no COMMAND LINE alternative for the ":Error" command to specifically output "just the errors".

The "-o" command line option is available, but it captures all logs.  The ":Error" command is especially useful, because an empty result signifies a good deployment.

Aka, I'm looking for a command line version of

:Error ".\JustTheErrors.txt"

via the command line (sqlcmd.exe).


Basically, any missing command line option available through other means should be made available (that makes sense of course).  
One other option that jumps out at me is:
which also is not available the command line (sqlcmd.exe)
Sign in to post a comment.
Posted by Microsoft on 6/21/2011 at 2:18 AM
Hello LoudRock,

Thank you for the feedback. We regret to inform you that we will not be fixing the reported issue.