What are the challenges you face when working across database platforms? Take the survey
Options

Synchronization Failure

mpascoempascoe Posts: 5
edited April 28, 2005 1:27PM in SQL Compare Previous Versions
I get the following error while trying to update a database:

The following error message was returned from the SQL Server:

[5074] The column 'units_available' is dependent on column 'units_on_hand'.
ALTER TABLE ALTER COLUMN units_on_hand failed because one or more objects access this column.

The following SQL command caused the error:

ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_on_hand] [int] NULL
ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_allocated] [int] NULL
ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_on_replenishment] [int] NULL


Any idea on how I can overcome this problem and synch this database?

Thanks for any help

Matthew Pascoe

Comments

This discussion has been closed.