SQL Server Errors or Failures Error: 226 to Error: 246
You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 226 to Error: 246
Error: 226, severity: 16,
%ls statement not allowed within multi-statement transaction.
Error: 227, severity: 15,
“%.*ls” is not a valid function, property, or field.
Error: 228, severity: 15,
Method ‘%.*ls’ of type ‘%.*ls’ in assembly ‘%.*ls’ does not return any value.
Error: 229, severity: 14,
The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’.
Error: 230, severity: 14,
The %ls permission was denied on the column ‘%.*ls’ of the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’.
Error: 231, severity: 11,
No such default. ID = %ld, database ID = %d.
Error: 232, severity: 16,
Arithmetic overflow error for type %ls, value = %f.
Error: 233, severity: 16,
The column ‘%.*ls’ in table ‘%.*ls’ cannot be null.
Error: 234, severity: 16,
There is insufficient result space to convert a money value to %ls.
Error: 235, severity: 16,
Cannot convert a char value to money. The char value has incorrect syntax.
Error: 236, severity: 16,
The conversion from char data type to money resulted in a money overflow error.
Error: 237, severity: 16,
There is insufficient result space to convert a money value to %ls.
Error: 239, severity: 16,
Duplicate common table expression name ‘%.*ls’ was specified.
Error: 240, severity: 16,
Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”.
Error: 241, severity: 16,
Conversion failed when converting date and/or time from character string.
Error: 242, severity: 16,
The conversion of a %ls data type to a %ls data type resulted in an out-of-range value.
Error: 243, severity: 16,
Type %.*ls is not a defined system type.
Error: 244, severity: 16,
The conversion of the %ls value ‘%.*ls’ overflowed an %hs column. Use a larger integer column.
Error: 245, severity: 16,
Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls.
Error: 246, severity: 16,
No anchor member was specified for recursive query “%.*ls”.
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.