Tag: SQL Server Errors

SQL Server Error Msg 6368 – It is not allowed to specify an XSD type for selective XML index ‘%.*ls’ because the column ‘%.*ls’ of table ‘%.*ls’ is associated with an XML Schema collection.

SQL Server Error Msg 9007 – Cannot shrink log file %d (%s) because requested size (%dKB) is larger than the start of the last logical log file.

SQL Server Error Msg 15413 – Cannot make a role a member of itself.

SQL Server Error Msg 18280 – The file %s is being removed from the database, but is not being removed from the filesystem because file snapshots are still associated with the file.

SQL Server Error Msg 3206 – Backup device ‘%.*ls’ does not exist. To view existing backup devices, use the sys.backup_devices catalog view. To create a new backup device use either sp_addumpdevice or SQL Server Management Studio.

SQL Server Error Msg 4452 – Cannot UPDATE partitioning column ‘%.*ls’ of view ‘%.*ls’ because the table ‘%.*ls’ has a CASCADE DELETE or CASCADE UPDATE constraint.

SQL Server Error Msg 7723 – Only a single filegroup can be specified while creating partition scheme using option ALL to specify all the filegroups.

SQL Server Error Msg 25640 – Maximum event size is smaller than configured event session memory. Specify a larger value for maximum event size, or specify 0.

SQL Server Error Msg 9341 – %sSyntax error near ‘%ls’, expected a step expression.

SQL Server Error Msg 16 – 12414

SQL Server Error Msg 32033 – The update job for the database mirroring monitor already exists.  To change the update period, use sys.sp_dbmmonitorchangemonitoring

SQL Server Error Msg The %.*ls function requires %d argument(s). – 15

SQL Server Error Msg 49928 – An error occurred during server setup. See previous errors for more information.

SQL Server Error Msg ALTER DATABASE failed. Recollating the database failed while altering the database ‘%.*ls’ to containment=’%ls’. – 16

SQL Server Error Msg 17070 – Clustered instances are not supported on this edition of SQL Server.

SQL Server Error Msg 14704 – Collects top-level performance indicators for the computer and the Database Engine. Enables analysis of resource use, resource bottlenecks, and Database Engine activity.

SQL Server Error Msg 40874 – The DTUs (%d) for the elastic pool does not belong to the specified values for service tier ‘%.*ls’.

SQL Server Error Msg 3997 – A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.

SQL Server Error Msg 22526 – An invalid value was specified for %s. Valid values are 0 (none), 1 (enforced partitions), 2 (nonoverlapping partitions with multiple subscriptions per partition), and 3 (nonoverlapping partitions with single subscription per partition).

SQL Server Error Msg 2717 – The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d).