Microsoft KB Archive/136448

{|
 * width="100%"|

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

 * }

Q136448

-

The information in this article applies to:


 * Microsoft SQL Server versions 4.2x, 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.

Additional query words: sql6

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2