Hi,

I think that these are what owen.pugh was referring to:

IF EXISTS (SELECTname FROM sys.databases WHERE name= N'MyDatabase')

should be

IF EXISTS (SELECT name FROM sysdatabases WHERE name= N'MyDatabase')

******

IF EXISTS (SELECT* FROM sys.objects WHERE

should be

IF EXISTS (SELECT * FROM sysobjects WHERE

******

object_id = OBJECT_ID(N'[dbo].[Employee]') ANDtype in (N'U'))

should be

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!

Cheers,

Todd