Tag: SQL Server Errors

SQL Server Error Msg 15182 – Cannot disable access to the guest user in master or tempdb.

SQL Server Error Msg Errors were encountered in the %S_MSG ‘%.*ls’ during compilation of the object. Either the containment option of the database ‘%.*ls’ was changed, or this object was present in model db and the user tried to create a new contained database. – 16

SQL Server Error Msg 18844 – Invalid compensation range: begin {%08lx:%08lx:%04lx}, end {%08lx:%08lx:%04lx}. Reinitialize all subscriptions to the publication.

SQL Server Error Msg System-versioned table schema modification failed because column ‘%.*ls’ in history table ‘%.*ls’ corresponds to a generated always column in table ‘%.*ls’ and cannot be nullable. – 16

SQL Server Error Msg 5061 – ALTER DATABASE failed because a lock could not be placed on database ‘%.*ls’. Try again later.

SQL Server Error Msg 21033 – Cannot drop server ‘%s’ as Distribution Publisher because there are databases enabled for replication on that server.

SQL Server Error Msg 3728 – ‘%.*ls’ is not a constraint.

SQL Server Error Msg 33120 – In order to encrypt the database encryption key with an %S_MSG, please use an %S_MSG that resides on an extensible key management provider.

SQL Server Error Msg 19057 – The boolean operator in the filter is not valid.

SQL Server Error Msg 10338 – Verification of assembly failed. Could not open the physical file ‘%.*ls’: %ls.

SQL Server Error Msg 15839 – ‘%ls’ is not supported by data_export.

SQL Server Error Msg 26041 – Server TCP provider has successfully reestablished listening on port [ %d ].

SQL Server Error Msg 3266 – The backup data at the end of “%ls” is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.

SQL Server Error Msg 31008 – Could not retrieve limit and job state information from DTA job object when invoking DTA for auto indexing.

SQL Server Error Msg 15587 – Cannot change owner of Assembly ‘%.*ls’ since dependent assembly ‘%.*ls’ is not owned by the new owner.

SQL Server Error Msg 4440 – UNION ALL view ‘%.*ls’ is not updatable because a primary key was not found on table ‘%.*ls’.

SQL Server Error Msg 6716 – XML Node ID is invalid.  Re-build the database if the problem persists.

SQL Server Error Msg 9736 – An error occurred in dialog transmission: Error: %i, State: %i. %.*ls

SQL Server Error Msg 7902 – Columnstore index ‘%.*ls’ on table ‘%.*ls’ has metadata mismatch on column id %d and rowgroup id %d. If this is a nonclustered columnstore index, drop it and recreate it. Otherwise, contact CSS.

SQL Server Error Msg 8114 – Error converting data type %ls to %ls.