Home Forums SQL Server 2005 Administering by mistake one Script on Master RE: by mistake one Script on Master

  • June 2, 2009 at 1:09 pm

    #1003595

    Randolph Potter (6/2/2009)

    Nice tip, John! I'm going to use it myself 🙂

    You're welcome. It is one of numerous defensive measures that I've implemented. Usually resulting from the school of "hard knocks".

    Just make sure that you use the -b (on error batch abort) switch when you run your script using SQLCMD.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]