• cmcklw (11/14/2008)


    Cliff Jones (11/14/2008)


    I am not sure why they changed the scripting so that it does not include the 'GO'? It is such a subtle little change that has caused us a lot of grief.

    I agree and I also miss the ability to have SSMS automatically script out the if exists drop at the beginning of the script as well!

    Yes, that is my other complaint. It used to be so simple to script out a single stored procedure in SQL 2000 and the result included the if exists and drop statement. It is much more cumbersome to do that in SQL 2005.