SQL Server Errors or Failures Error: 290 to Error: 312



Error: 290, severity 16,
Invalid EXECUTE statement using object “%ls”, method “%ls”.

Error: 291, severity 16,
CAST or CONVERT: invalid attributes specified for type ‘%.*ls’

Error: 292, severity 16,
There is insufficient result space to convert a smallmoney value to %ls.

Error: 293, severity 16,
Cannot convert char value to smallmoney. The char value has incorrect syntax.

Error: 294, severity 16,
The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.

Error: 295, severity 16,
Conversion failed when converting character string to smalldatetime data type.

Error: 297, severity 16,
The user does not have permission to perform this action.

Error: 300, severity 14,
%ls permission was denied on object ‘%.*ls’, database ‘%.*ls’.

Error: 301, severity 16,
Query contains an outer-join request that is not permitted.

Error: 302, severity 16,
The newsequentialid built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CRATE TBL or ALTER TBL statement. It cannot be combined with other operators to form a complex scalar expression.

Error: 303, severity 16,
The table ‘%.*ls’ is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.

Error: 304, severity 16,
‘%d’ is out of range for index option ‘%.*ls’. See sp_configure option ‘%ls’ for valid values.

Error: 305, severity 16,
The XML data type cannot be compared or sorted, except when using the IS NULL operator.

Error: 306, severity 16,
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Error: 307, severity 16,
Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error: 308, severity 16,
Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error: 309, severity 16,
Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints.

Error: 310, severity 15,
The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.

Error: 311, severity 16,
Cannot use text, ntext, or image columns in the ‘inserted’ and ‘deleted’ tables.

Error: 312, severity 16,
Cannot reference text, ntext, or image columns in a filter stored procedure.

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 *