I was getting the following error in a stored procedure that I had written. Nothing fancy in it as far as concern with using any new features of SQL 2005.
Msg 321, Level 15, State 1, Line 5
"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function,
ensure that your database compatibility mode is set to 90.
I googled about it and most of the places (like this) the answers are about checking the database compatibility. I looked at our database's configuration and everything seemed fine to me.
Then I realized that I had used the dynamic sql in the stored proc and between two lines of the sql statements, I had forgotten the "space" and that's why I was getting that error. How the hell on the earth that has to do with the error message above?
Why can't SQL management studio give better (correct) error message? Come on, am I asking for too much here?