SQL Server Errors or Failures Error: 500 to Error: 530
Error: 500, Severity: 16,
Trying to pass a table-valued parameter with %d column(s) where the corresponding user-defined table type requires %d column(s).
Error: 505, Severity: 16,
The current user account was invoked with SETUSER or SP_SETAPPROLE. Changing databases is not allowed.
Error: 506, Severity: 16,
The invalid escape character “%.*ls” was specified in a %ls predicate.
Error: 507, Severity: 16,
Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.
Error: 509, Severity: 11,
User name ‘%.*ls’ not found.
Error: 510, Severity: 16,
Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.
Error: 511, Severity: 16,
Cannot create a row of size %d which is greater than the allowable maximum row size of %d.
Error: 512, Severity: 16,
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Error: 513, Severity: 16,
A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database ‘%.*ls’, table ‘%.*ls’, column ‘%.*ls’.
Error: 515, Severity: 16,
Cannot insert the value NULL into column ‘%.*ls’, table ‘%.*ls’; column does not allow nulls. %ls fails.
Error: 517, Severity: 16,
Adding a value to a ‘%ls’ column caused an overflow.
Error: 518, Severity: 16,
Cannot convert data type %ls to %ls.
Error: 522, Severity: 16,
The WAITFOR thread was evicted.
Error: 523, Severity: 16,
A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.
Error: 524, Severity: 16,
A trigger returned a resultset and the server option ‘disallow results from triggers’ is true.
Error: 525, Severity: 16,
The column that was returned from the nodes() method cannot be converted to the data type %ls. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.
Error: 526, Severity: 16,
%ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query.
Error: 527, Severity: 16,
Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query.
Error: 529, Severity: 16,
Explicit conversion from data type %ls to %ls is not allowed.
Error: 530, Severity: 16,
The statement terminated. The maximum recursion %d has been exhausted before statement completion.
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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.