SQL Server Errors or Failures from Error: 12825 to Error: 12980

 

Error: 12825, Severity: 16, The database cannot be contained; this functionality is not available in the current edition of SQL Server.
Error: 12826, Severity: 16, RECONFIGURE WITH OVERRIDE set the ‘contained database authentication’ to 0 while there are contained databases in use. This will disrupt authentication for contained users and will not allow new contained databases to be created.
Error: 12827, Severity: 16, User-named %ls constraint ‘%.*ls’ is not allowed on temp table ‘%.*ls’ because it is being created in a contained database. Please consult the Books Online topic Understanding Contained Databases for more information on contained databases.
Error: 12828, Severity: 16, User-defined %S_MSG ‘%.*ls’ in tempdb cannot be referenced from local temp table ‘%.*ls’ because the temp table is being created in a contained

database. Please consult the Books Online topic Understanding Contained Databases for more information on conta
Error: 12829, Severity: 16, The stored procedure ‘%.*ls’ refers to a group of numbered stored procedures. Numbered stored procedures are not available in contained databases. Please consult the Books Online topic Understanding Contained Databases for more information on contained da
Error: 12830, Severity: 16, The sp_configure ‘user options’ setting must be zero if the Database Engine has contained databases.
Error: 12831, Severity: 16, Database ‘%.*ls’ is a contained database. The option ‘contained database authentication’ setting is 0. Users with passwords will not be able to login to contained databases.
Error: 12832, Severity: 16, The database ‘%.*ls’ could not be created or altered to a contained database, because the schema bound %S_MSG ‘%.*ls’ depends on builtin function ‘%s’. In a contained database, the output collation of this builtin function has changed to ‘%.*ls’, which di

Error: 12833, Severity: 16, The database ‘%.*ls’ could not be created or altered to a contained database, because the check constraint ‘%.*ls’ on table ‘%.*ls’ depends on builtin function ‘%s’. In a contained database, the output collation of this builtin function has changed to ‘%.
Error: 12834, Severity: 16, The database ‘%.*ls’ could not be created or altered to a contained database, because the computed column ‘%.*ls’ on %S_MSG ‘%.*ls’ depends on builtin function ‘%s’. In a contained database, the output collation of this builtin function has changed to ‘%.
Error: 12835, Severity: 10, The definition of the %S_MSG ‘%.*ls’ was refreshed as part of altering the containment option of the database ‘%.*ls’ because the object depends on builtin function ‘%s’. In a contained database, the output collation of this builtin function has changed t
Error: 12836, Severity: 16, ALTER DATABASE statement failed. The containment option of the database ‘%.*ls’ could not be altered because compilation errors were encountered during validation of SQL modules. See previous errors.
Error: 12837, Severity: 16, CREATE DATABASE statement failed. The contained database ‘%.*ls’ could not be created because compilation errors were encountered during validation of SQL modules. See previous errors.
Error: 12838, Severity: 16, Replication, Change Data Capture and Change Tracking are not supported in contained databases. The database ‘%.*ls’ cannot be altered to a contained database, since it has one of these options turned on.
Error: 12839, Severity: 16, Replication, Change Data Capture and Change Tracking are not supported in contained databases. The option cannot be enabled on the contained database ‘%s’.
Error: 12840, Severity: 16, CREATE DATABASE failed. Recollating the database failed while creating the partially contained database ‘%.*ls’, with a default data collation of ‘%.*ls’.
Error: 12841, Severity: 16, ALTER DATABASE failed. Recollating the database failed while altering the database ‘%.*ls’ to containment=’%ls’.
Error: 12842, Severity: 16, The COLLATE CATALOG_DEFAULT clause cannot be used in a constraint, computed column, index filter expression, or any schema-bound object.
Error: 12843, Severity: 16, The containment state of database ‘%.*ls’ does not match the value in master. Contained database functionality will not work as expected. Detach and re-attach the database to correct the database state in master.
Error: 12980, Severity: 16, Supply either %s or %s to identify the log entries.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.