SQL Server Errors or Failures Error: 2792 to Error: 3006

SQLServerF1

 

Error: 2792, Severity: 16, Cannot specify a sql CLR type in a Schema-bound object or a constraint expression.,
Error: 2793, Severity: 16, Specified owner name ‘%.*ls’ either does not exist or you do not have permission to act on its behalf.,
Error: 2794, Severity: 16, Message text expects more than the maximum number of arguments (%d).,
Error: 2795, Severity: 16, Could not %S_MSG %S_MSG because the new %S_MSG ‘%.*ls’ does not match the FILESTREAM %S_MSG ‘%.*ls’ of the table.,
Error: 2796, Severity: 16, Cannot specify database name with $partition in a Schema-bound object, computed column or constraint expression.,

Error: 2797, Severity: 16, The default schema does not exist.,
Error: 2798, Severity: 16, Cannot create index or statistics ‘%.*ls’ on table ‘%.*ls’ because SQL Server cannot verify that key column ‘%.*ls’ is precise and deterministic. Consider removing column from index or statistics key, marking computed column persisted, or using non-CLR-de,
Error: 2799, Severity: 16, Cannot create index or statistics ‘%.*ls’ on table ‘%.*ls’ because the computed column ‘%.*ls’ is imprecise and not persisted. Consider removing column from index or statistics key or marking computed column persisted.,
Error: 2801, Severity: 16, The definition of object ‘%.*ls’ has changed since it was compiled.,
Error: 2802, Severity: 10, SQL Server has encountered %d occurrence(s) of cachestore flush for the ‘%s’ cachestore (part of plan cache) due to ‘DBCC FREEPROCCACHE’ or ‘DBCC FREESYSTEMCACHE’ operations.,
Error: 2803, Severity: 10, SQL Server has encountered %d occurrence(s) of cachestore flush for the ‘%s’ cachestore (part of plan cache) due to some database maintenance or reconfigure operations.,
Error: 2809, Severity: 16, The request for %S_MSG ‘%.*ls’ failed because ‘%.*ls’ is a %S_MSG object.,

Error: 2812, Severity: 16, State: 1, Line: 1
Msg: 2812, Level: 16, State: 1, Line: 1
Could not find stored procedure ‘%.*ls’

This error occurs if the name of the stored procedure specified in the query does not exist on the database. Verify that you are running the query against the correct database and make sure there are no spelling mistakes with the name of the stored procedure
Error: 2813, Severity: 16, %.*ls is not supported on this edition of SQL Server.,
Error: 2814, Severity: 10, A possible infinite recompile was detected for SQLHANDLE %hs, PlanHandle %hs, starting offset %d, ending offset %d. The last recompile reason was %d.,
Error: 3002, Severity: 16, Cannot BACKUP or RESTORE a database snapshot.,
Error: 3003, Severity: 10, This BACKUP WITH DIFFERENTIAL will be based on more than one file backup. All those file backups must be restored before attempting to restore this differential backup.,
Error: 3004, Severity: 16, The primary filegroup cannot be backed up as a file backup because the database is using the SIMPLE recovery model. Consider taking a partial backup by specifying READ_WRITE_FILEGROUPS.,
Error: 3005, Severity: 10, The differential partial backup is including a read-only filegroup, ‘%ls’. This filegroup was read-write when the base partial backup was created, but was later changed to read-only access. We recommend that you create a separate file backup of the ‘%ls’ ,
Error: 3006, Severity: 16, The differential backup is not allowed because it would be based on more than one base backup. Multi-based differential backups are not allowed in the simple recovery model, and are never allowed for partial differential backups.,

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *