Activity overview
Latest activity by jcavaliere
No Problem - we just want to make it all work [image]
Here's an example, but it happens with just about all of the foreign keys and check constraints if the schema is not dbo:
ALTER TABLE [RxOrder].[LineItem] WITH CHECK ADD CONSTRAINT RxOrder.LineItem_Eye_Chk] CHECK (([Eye]='L' OR [Eye]='R'))
The RxOrder.LineItem_Eye_Chk] throws an error when run becuase of the second set of [] brackes in the name. / comments
No Problem - we just want to make it all work
Here's an example, but it happens with just about all of the foreign keys and check constraints if the schema is not dbo:
ALTER TABLE [RxOrder].[LineI...
Invalid change scripts for database schemas?
Hi All,
We recently started incorporating database schemas in SQL 2005 and are looking to migrate some DDL changes to the production servers. We used SQL compare with MS SQL 2000 which worked beau...