owen.pugh (7/15/2008)
Thanks for the article.:D It provides useful information but is let down by the level of grammar and spelling - making it unlcear in places.:unsure:I'm looking forward to Part 2.
Cheers
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