Errors in script

derekmbderekmb Posts: 2
edited October 27, 2008 11:47AM in SQL Compare Previous Versions
Hi Guys,
I am a new user. I get the following errors when I try to run a compare script. Does anyone have any ideas?

Thanks,
Derek

Altering [dbo].[PendingProductionAdjustment_SetProcessedFlag]
Server: Msg 207, Level 16, State 1, Procedure PendingProductionAdjustment_SetProcessedFlag, Line 18
Invalid column name 'IsProcessed'.

(1 row(s) affected)

Creating [dbo].[PLCWIPMasterPanel_Insert]
Server: Msg 207, Level 16, State 3, Procedure PLCWIPMasterPanel_Insert, Line 69
Invalid column name 'PressOpenings'.
Server: Msg 207, Level 16, State 1, Procedure PLCWIPMasterPanel_Insert, Line 69
Invalid column name 'PanelsPerPressOpening'.

(1 row(s) affected)

Altering [dbo].[RSSQL.InsertUnit_Cordele]
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'BarcodeWMS_Test.dbo.PLCProduction_Insert'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'BarcodeWMS_test.dbo.PLCProduction_Insert'. The stored procedure will still be created.
Binding defaults to columns
Server: Msg 15104, Level 16, State 1, Procedure sp_bindefault, Line 140
You do not own a table named 'PLCProductionQueueEventLog' that has a column named 'EventLogDate'.

Adding constraints to [dbo].[Order Header_Temp]
Server: Msg 1781, Level 16, State 1, Line 1
Column already has a DEFAULT bound to it.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)

Adding constraints to [dbo].[Order Shipment Details_Temp]
Server: Msg 1781, Level 16, State 1, Line 1
Column already has a DEFAULT bound to it.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)

Adding foreign keys to [dbo].[EIMessages]
Server: Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_Messages_MessageTypes' in the database.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)

Comments

Sign In or Register to comment.