Server: Msg 107, Level 16, State 3 Error 
Author Message
 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
 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
 
 [ 2 post ] 

 Relevant Pages 

1. Msg 107, level 16, state 3

2. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

3. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

4. Error Message: Server: Msg 7392, Level 16, State 2

5. HELP - SQL Server 7.0 Error - Msg 542, Level 16, State 1

6. Error: Server: MSG 7392, Level 16, State 2

7. Select error:Server: Msg 8120, Level 16, State 1, Line 1

8. Msg 5159, Level 16, State 1 OS Error 38

9. Msg 207, Level 16, State 1 - bizarre error

10. SQLServer Msg 2506, Level 16, State 3 Error - Help Needed

11. Getting Error Msg 7343, Level 16, State 4

12. Error Msg: 7343, Level 16, State 4 (linking Database)


 
Powered by phpBB® Forum Software