duplicate key was found for the object name 'dbo.syscolpars'

23 Views Asked by At
ALTER DATABASE testDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 

GO 

ALTER DATABASE testDatabase COLLATE SQL_Latin1_General_CP1253_CI_AI; 

GO 

ALTER DATABASE testDatabase SET MULTI_USER; 

GO 

Error :

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.syscolpars' and the index name 'nc'. The duplicate key value is (397960494, Categorie, 0).
Msg 5072, Level 16, State 1, Line 5

I'm trying to alter the database collation, and i'm getting this error, i don't understand why, tried to select the dbo.syscolpars, but i'm unable to/don't know how, please enlighten me !!

0

There are 0 best solutions below