When doing a GP9 to GP 2010 upgrade, I got this error:
Msg 15148, Level 16, State 1, Procedure sp_bindefault, Line 230
The data type or table column '[eConnect_Out].[DBNAME]' does not exist or you do not have permission.
The 'more' window gave me this
The following SQL statement produced an error:
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[DOCTYPE]'
EXEC sp_bindefault N'[dbo].[TA_DATE]', N'[eConnect_Out].[DATE1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[TABLENAME]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[DEX_ROW_ID]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX1]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX2]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX3]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX4]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX5]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX6]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX7]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX8]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX9]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX10]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX11]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX12]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX13]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX14]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[eConnect_Out].[INDEX15]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[ACTION]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[eConnect_Out].[REPLICATE]'
EXEC sp_bindefault N'[dbo].[TA_DBNAME]', N'[eConnect_Out].[DBNAME]'
GRANT REFERENCES , SELECT , INSERT , DELETE , UPDATE ON dbo.eConnect_Out TO DYNGRP