Errors in script
derekmb
Posts: 2
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)
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
Could you please e-mail us the script that you are trying to run?
If you could also include a SQL Compare snapshot of the source and destination that would be useful.
Please e-mail them to support@red-gate.com quoting Call reference number F0016496.
Thanks,
Redgate Foundry