Thank you for the confirmation - this was really driving me crazy. I've opened a Connect item for it. If you have a chance, please upvote it!

https://connect.microsoft.com/SQLServer/feedback/details/756984/sqlcmd-doesnt-exit-when-using-raiserror-50001-10-127

Hello Sean,

I need the GO terminator - these scripts create procedures, drop tables, etc. Does the terminator override the cancellation?

I must agree with a previous poster that wonders why we should take a pay cut for the "privilege" of working from home. It saves the company a great...

One of the testing approaches I implemented in my last position was as follows:

1) all code development for SQL was fully scripted in independent files in version control.

2) a single...

I find that the most interesting part of this thread is that most people are answering with an alternate IT-driven profession. Is this because systems are their passion or...

I spend more of my time on the development side rather than the DBA side. To help with overall testing, I've taken to creating a set of test data...

Hello Gail,

Thank you - that works like a charm. Obviously, I need to spend some more time in security class! If you are coming to PASS in Seattle...

As you mention in the article I maintain audit trails by storing both a start date and an end date in my history tables. How is the overall performance...

From an internal systems viewpoint, we write code to a specific platform (SQL Server) and have completly turned our backs on portability.  We chose a platform that would work well...

Slick enough!  Thanks for all your help.

Those two lines in the middle must have crept in during a cut and paste - I had to post this twice since the...

Hello all,

For local development I have been relying on the "local administrators" being sysadmins in SQL by default (I know, bad practice ;-).  This service pack removes this default role,...

Hello Julian,

I suppose I will be one of the ones to slam the "Entity Attribute Value" approach, but I do understand its value in this scenario.

Would you consider a limiting...

Hello Jane,

The "Name" field is a special case.  I don't like to use reserved words for column names, so the prefix prevents this.

Hello all,

You are correct Lance, you can't please everyone!  I wrote this article not as a panacea for all situations but rather as a starting point for others to develop...

SOLVED: thanks to lucky, and special thanks to MG.

My guess is that "file missing" errors are directed to STDOUT in osql, but to STDERR in sqlcmd.  The following script will...