• Lynn Pettis (10/28/2016)


    Chris Wooding (10/27/2016)


    Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking at stored procedures, functions, etc. The reason is that what happened to you has happened to me - exactly once.

    I do the same thing as a safety net.

    Especially true if your window is connected to a database source. In these situations I like to also "disconnect" from the source after scripting to a new editor window, just to leave no room for error.

    ----------------------------------------------------