• dwain.c (3/24/2013)


    kapil_kk (3/24/2013)


    This wil also give error :

    DROP FUNCTION dbo.Test DROP TYPE dbo.MyTable GO

    as GO is present at the same line where it should not be....

    Alas I got wrong :w00t:

    I'll refer you back to my answer to Tom's post just a little ways back.

    Clearly that last line should appear as:

    DROP FUNCTION dbo.Test

    DROP TYPE dbo.MyTable

    GO

    Thanks 🙂

    I have requested Steve to fix it if he can. Hopefully it won't confuse too many others.

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/