SQL Server Errors or Failures Error: 268 to Error: 289


You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 268 to Error: 289

Error: 268, severity 16,
Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.

Error: 270, severity 16,
Object ‘%.*ls’ cannot be modified.

Error: 271, severity 16,
The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator.

Error: 272, severity 16,
Cannot update a timestamp column.

Error: 273, severity 16,
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

Error: 275, severity 16,
Prefixes are not allowed in value or pivot columns of an UNPIVOT operator.

Error: 276, severity 16,
Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator.

Error: 277, severity 16,
The column “%.*ls” is specified multiple times in the column list of the UNPIVOT operator.

Error: 278, severity 16,
The text, ntext, and image data types cannot be used in a GROUP BY clause.

Error: 279, severity 16,
The text, ntext, and image data types are invalid in this subquery or aggregate expression.

Error: 280, severity 16,
Only base table columns are allowed in the TEXTPTR function.

Error: 281, severity 16,
%d is not a valid style number when converting from %ls to a character string.

Error: 282, severity 10,
The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

Error: 283, severity 16,
READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.

Error: 284, severity 16,
Rules cannot be bound to text, ntext, or image data types.

Error: 285, severity 16,
The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.

Error: 286, severity 16,
The logical tables INSERTED and DELETED cannot be updated.

Error: 287, severity 16,
The %ls statement is not allowed within a trigger.

Error: 288, severity 16,
The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

Error: 289, severity 16,
Cannot construct data type %ls, some of the arguments have values which are not valid.

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 *