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.


2
0
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

Description

http://msdn.microsoft.com/en-us/library/ms162773.aspx

//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).


............

Additionally:
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:
:Perftrace
which also is not available the command line (sqlcmd.exe)
Sign in to post a comment.
Posted by MANU [MSFT] 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.

Thanks,
Manu.