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/