I've run the following to change our database to case insensitive (installed instance of sql 2000, then attached db into it):
ALTER DATABASE X
COLLATE SQL_Latin1_General_CP1_CI_AS
It fails on all the Check Constraints objects (over 2100 of them). I've also read that I cannot alter table to change the sort order if a table has a constraint on it.
Is there anyway to drop the constraints first, then run alter database, then recreate just the constraints? It looks like I'll have to drop each table, recreate in case-insentive, then DTS or bcp in. Yuck.
Has anyone successfully done this?
ALTER DATABASE X
COLLATE SQL_Latin1_General_CP1_CI_AS
It fails on all the Check Constraints objects (over 2100 of them). I've also read that I cannot alter table to change the sort order if a table has a constraint on it.
Is there anyway to drop the constraints first, then run alter database, then recreate just the constraints? It looks like I'll have to drop each table, recreate in case-insentive, then DTS or bcp in. Yuck.
Has anyone successfully done this?