SQL Server Errors or Failures Error: 531 to Error: 555



Error: 531, Severity: 10,
Cannot set NOCOUNT to OFF inside the trigger execution because the server option “disallow_results_from_triggers” is true or we are inside LOGON trigger execution.

Error: 532, Severity: 16,
The timestamp (changed to %S_TS) shows that the row has been updated by another user.

Error: 533, Severity: 15,
Cannot set XACT ABORT to OFF inside the trigger execution.

Error: 534, Severity: 16,
‘%.*ls’ failed because it is not supported in the edition of this SQL Server instance ‘%.*ls’. See books online for more details on feature support in different SQL Server editions.

Error: 535, Severity: 16,
The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

Error: 536, Severity: 16,
Invalid length parameter passed to the %ls function.

Error: 537, Severity: 16,
Invalid length parameter passed to the LEFT or SUBSTRING function.

Error: 539, Severity: 16,
Schema changed after the target table was created. Rerun the Select Into query.

Error: 540, Severity: 16,
There is insufficient system memory to run RAISERROR.

Error: 541, Severity: 16,
There is not enough stack to execute the statement

Error: 542, Severity: 16,
An invalid datetime value was encountered. Value exceeds the year 9999.

Error: 543, Severity: 16,
Creation of a return table failed for the table valued function ‘%.*ls’.

Error: 544, Severity: 16,
Cannot insert explicit value for identity column in table ‘%.*ls’ when IDENTITY_INSERT is set to OFF.

Error: 545, Severity: 16,
Explicit value must be specified for identity column in table ‘%.*ls’ either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

Error: 547, Severity: 16,
The %ls statement conflicted with the %ls constraint “%.*ls”. The conflict occurred in database “%.*ls”, table “%.*ls”%ls%.*ls%ls.

Error: 548, Severity: 16,
The insert failed. It conflicted with an identity range check constraint in database ‘%.*ls’, replicated table ‘%.*ls’%ls%.*ls%ls. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_a

Error: 549, Severity: 16,
The collation ‘%.*ls’ of receiving variable is not equal to the collation ‘%.*ls’ of column ‘%.*ls’.

Error: 550, Severity: 16,
The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.

Error: 552, Severity: 16,
CryptoAPI function ‘%ls’ failed. Error 0x%x: %ls

Error: 555, Severity: 16,
User-defined functions are not yet enabled.

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 *