Friday, September 02, 2005

The identifier that starts with "SELECT * FROM ...." is too long. Maximum length is 128.

This morning as I was working on a project, I tested a SQL statement in Query Analyzer, but got the following error:

Server: Msg 103, Level 15, State 7, Line 1The identifier that starts with "SELECT * FROM ...." is too long. Maximum length is 128.

After searching on the internet, I found a solution at http://support.microsoft.com/default.aspx?scid=kb;EN-US;294839. Microsoft recommends installing SP1 to resolve this and it worked.

No comments: