Article - CS293867
Unable to change the Containment type of Microsoft SQL Server Database for Windchill PDMLink
Modified: 17-Jan-2023
Applies To
- Windchill PDMLink 6.2 to 11.1
Description
- Unable to change the Containment type of Microsoft SQL Server Database for Windchill PDMLink
- SQL Server Management Studio throws the error below :
- Error 1:
Msg 12814, Level 16, State 1, Procedure wt_get_next_sequence_currentcountervalue_seq, Line 8
The object referenced as 'currentcountervalue_seq' resolves differently in the target metadata collation 'Latin1_General_100_CI_AS_KS_WS_SC' than in the current metadata collation 'SQL_Latin1_General_CP1_CS_AS'.
Msg 12813, Level 16, State 2, Line 5
Errors were encountered in the procedure '.wt_get_next_sequence_currentcountervalue_seq' during compilation of the object. Either the containment option of the database 'DBNAME' was changed, or this object was present in model db and the user tried to create a new contained database.
Msg 12836, Level 16, State 1, Line 5
ALTER DATABASE statement failed. The containment option of the database 'DBNAME' could not be altered because compilation errors were encountered during validation of SQL modules. See previous errors.
Msg 5069, Level 16, State 1, Line 5
ALTER DATABASE statement failed.
The object referenced as 'currentcountervalue_seq' resolves differently in the target metadata collation 'Latin1_General_100_CI_AS_KS_WS_SC' than in the current metadata collation 'SQL_Latin1_General_CP1_CS_AS'.
Msg 12813, Level 16, State 2, Line 5
Errors were encountered in the procedure '.wt_get_next_sequence_currentcountervalue_seq' during compilation of the object. Either the containment option of the database 'DBNAME' was changed, or this object was present in model db and the user tried to create a new contained database.
Msg 12836, Level 16, State 1, Line 5
ALTER DATABASE statement failed. The containment option of the database 'DBNAME' could not be altered because compilation errors were encountered during validation of SQL modules. See previous errors.
Msg 5069, Level 16, State 1, Line 5
ALTER DATABASE statement failed.
- Error 2 :
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.sysschobjs' and the index name 'nc1'. The duplicate key value is (0, 6, <TableName>).
This is a printer-friendly version of Article 293867 and may be out of date. For the latest version click CS293867