Thanks for the article.
It provides useful information but is let down by the level of grammar and spelling - making it unlcear in places.
I'm looking forward to Part 2.
I think that these are what owen.pugh was referring to:
IF EXISTS (SELECTname FROM sys.databases WHERE name= N'MyDatabase')
IF EXISTS (SELECT name FROM sysdatabases WHERE name= N'MyDatabase')
IF EXISTS (SELECT* FROM sys.objects WHERE
IF EXISTS (SELECT * FROM sysobjects WHERE
object_id = OBJECT_ID(N'[dbo].[Employee]') ANDtype in (N'U'))
object_id = OBJECT_ID(N'[dbo].[Employee]') AND type in (N'U'))
It might seem nitpicky, but as a newbie it took a while before I was able to figure out that sys.objects and sys.databases were not the correct names. The spaces that were left out weren't such a big deal, but this wouldn't run right from a copy/paste.
UPDATE: I missed a page of posts, but I now realize that these were not what owen.pugh was referring to (Sorry owen.pugh for the misinterpretation of your comments). I still believe that the errors I listed above make this article a little harder to follow. All in all, this was a very informative article, though. Thanks, MAK!