MS SQL Server, Server: Msg 107, Level 16, State 3 Error

Server: Msg 107, Level 16, State 3 Error

Author	Message
Imra #1 / 2	Server: Msg 107, Level 16, State 3 Error Hello everyone, I am getting the error message "Server: Msg 107, Level 16, State 3, Line 0 The column prefix "book" does not match with a table name or alias name used in query" I beleive this error occurs when the from clause in the query does not contain the table name being referenced here. But I cannot seem to pinpoint the location of the error in the code since the column name "book" is referenced a number of times in the sql file and the stored procedures called from it. Is there any way I can pinpoint the location of this error? ANy good way to debug errors like these? Thanks, Ik
Sun, 09 Jan 2005 03:02:52 GMT

Keith Kratochvi #2 / 2	Server: Msg 107, Level 16, State 3 Error Please do not multipost Please refer to your post within .server. -- Keith, SQL Server MVP Quote: > Hello everyone, > I am getting the error message > "Server: Msg 107, Level 16, State 3, Line 0 > The column prefix "book" does not match with a table name or alias name used > in query" > I beleive this error occurs when the from clause in the query does not > contain the table name being referenced here. But I cannot seem to pinpoint > the location of the error in the code since the column name "book" is > referenced a number of times in the sql file and the stored procedures > called from it. Is there any way I can pinpoint the location of this error? > ANy good way to debug errors like these? > Thanks, > Ik
Sun, 09 Jan 2005 03:30:23 GMT

Page 1 of 1

[ 2 post ]