I have a constraint (named INVS_ITEM_LOCATIONS_PK ) on my SQL Server 2005 table.
INVS_ITEM_LOCATIONS_PK
How do I disable it?
ALTER TABLE INVS_ITEM_LOCATIONS NOCHECK CONSTRAINT INVS_ITEM_LOCATIONS_PK
I'm not sure if you can disable the restriction, maybe you need to SPECIFY the restriction?