BUG: User-defined Comments May Cause Syn Errors in Obj Scripts

• Microsoft SQL Server, versions 4.2x and 6.0

SYMPTOMS

If you add user-defined comments to an object by inserting into the syscomments system table and a script is generated for this object, when you run the script against SQL Server version 4.2x you will get syntax errors using SQL Object Manager; or, when you run the script against SQL Server version 6.0, it will generate error 128 using SQL Server distributed management objects (SQL-DMO).

The user-defined comments will be inserted into the script with no comment marks and will cause the scripts not to create the objects.

WORKAROUND

When you insert the comments into the syscomments table, comment-out your comments by adding "/*" to the beginning of the comment and "*/" to the end. Then, when a script is generated, your comment is already commented out.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.