SQL Server Errors or Failures Error: 247 to Error: 267


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

Error: 247, severity: 16,
An anchor member was found in the recursive part of recursive query “%.*ls”

Error: 248, severity: 16,
The conversion of the %ls value ‘%.*ls’ overflowed an int column

Error: 249, severity: 16,
The type “%ls” is not comparable. It cannot be used in the %ls Clause

Error: 251, severity: 16,
Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded

Error: 252, severity: 16,
Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator

Error: 253, severity: 16,
Recursive member of a common table expression ‘%.*ls’ has multiple recursive references

Error: 254, severity: 16,
Prefixed columns are not allowed in the column list of a PIVOT operator

Error: 255, severity: 16,
Pseudocolumns are not allowed in the column list of a PIVOT operator

Error: 256, severity: 16,
The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary

Error: 257, severity: 16,
Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query

Error: 258, severity: 15,
Cannot call methods on %ls

Error: 259, severity: 16,
Ad hoc updates to system catalogs are not allowed

Error: 260, severity: 16,
Disallowed implicit conversion from data type %ls to data type %ls, table ‘%.*ls’, column ‘%.*ls’. Use the CONVERT function to run this query

Error: 261, severity: 16,
‘%.*ls’ is not a recognized function

Error: 262, severity: 16,
%ls permission denied in database ‘%.*ls’

Error: 263, severity: 16,
Must specify table to select from

Error: 264, severity: 16,
The column name ‘%.*ls’ is specified more than once in the SET clause or column list of an INSERT.
A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement up.

Error: 265, severity: 16,
The column name “%.*ls” specified in the %ls operator conflicts with the existing column name in the %ls argument

Error: 266, severity: 16,
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld

Error: 267, severity: 16,
Object ‘%.*ls’ cannot be found

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 *