SQL procedure Error - Msg 207, Level 16, State 1
Posted on 2014-02-05
I have a SQL database on a SQL 2008 server that I want to transfer to a SQL 2005 server.
I generated two scripts to create the tables with data and the stored procedures separately.
I ran the two scripts on the 2005 SQL server and the tables procedure ran successfully creating all the tables, but the stored procedure query ran with errors and example of one is as follows
Msg 207, Level 16, State 1, Procedure IPClstClient, Line 111
Invalid column name 'intauto'.
but intAuto does exist in the physical table when i look at it.
I ran the two procedures on another 2008 SQL server and they ran successfully so i know the procedures work.
Any ideas why this may be happening?