SQL Server Errors or Failures Error: 2761 to Error: 2791



Error: 2761, Severity: 16, The ROWGUIDCOL property can only be specified on the uniqueidentifier data type.,
Error: 2762, Severity: 16, sp_setapprole was not invoked correctly. Refer to the documentation for more information.,
Error: 2766, Severity: 16, The definition for user-defined data type ‘%.*ls’ has changed.,
Error: 2767, Severity: 15, Could not locate statistics ‘%.*ls’ in the system catalogs.,
Error: 2770, Severity: 16, The SELECT INTO statement cannot have same source and destination tables.,

Error: 2772, Severity: 16, Cannot access temporary tables from within a function.,
Error: 2773, Severity: 16, The collation ID is corrupted because the sort order ID %d is not valid.,
Error: 2774, Severity: 16, Collation ID %d is invalid.,
Error: 2775, Severity: 16, The code page %d is not supported by the server.,
Error: 2778, Severity: 16, Only System Administrator can specify %s option for %s command.,
Error: 2779, Severity: 16, The %S_MSG ‘%.*ls’ is an auto-drop system object. It cannot be used in queries or DDL.,
Error: 2780, Severity: 16, View ‘%.*ls’ is not schemabound.,
Error: 2782, Severity: 16, Cannot create table “%.*ls”: A table must have a clustered primary key in order to have XML data type columns.,

Error: 2785, Severity: 16, User-defined functions, user-defined aggregates, CLR types, and methods on CLR types are not allowed in expressions in this context.,
Error: 2786, Severity: 16, The data type of substitution parameter %d does not match the expected type of the format specification.,
Error: 2787, Severity: 16, Invalid format specification: ‘%.*ls’.,
Error: 2788, Severity: 16, Synonyms are invalid in a schemabound object or a constraint expression.,
Error: 2789, Severity: 16, Must specify a two-part name for %S_MSG ‘%.*ls’ in a schemabound object or a constraint expression.,
Error: 2790, Severity: 16, Cannot use a column of type TEXT, NTEXT, or IMAGE in a constraint expression.,
Error: 2791, Severity: 16, Could not resolve expression for Schema-bound object or constraint.,

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.

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 *