Missing end comment mark ‘*/’.

Error Message:
Msg 113, Level 15, State 1, Line 5
Missing end comment mark ‘*/’.

Severity level:

This error message appears when for a potentially multi-lined comment /* no ending comment token */ was typed.

The SQL statement cannot be parsed and further execution is stopped.

Error of the severity level 16 are generated by the user and can be fixed by the SQL Server user. In this case either the missing end comment token */ needs to be inserted at the appropriate place or the beginning comment token needs to be removed.

All versions of SQL Server.

  FROM Northwind.dbo.Orders
 WHERE OrderID = 10289

This should be a rather odd error, because most editors, like the SQL Server Management Studio, use different colors to highlight certain elements of Transact-SQL. When you type the beginning of a comment with a /* all following characters are colored in the comment-assigned color.


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |