SQL Server Errors or Failures from Error: 8136 to Error: 8156



Error: 8136, Severity: 16, Duplicate columns specified in %ls constraint key list, table ‘%.*ls’.
Error: 8137, Severity: 16, Incorrect use of the XML data type method ‘%.*ls’. A non-mutator method is expected in this context.
Error: 8138, Severity: 16, More than 16 columns specified in foreign key column list, table ‘%.*ls’.
Error: 8139, Severity: 16, Number of referencing columns in foreign key differs from number of referenced columns, table ‘%.*ls’.
Error: 8140, Severity: 16, More than one key specified in column level %ls constraint, table ‘%.*ls’.

Error: 8141, Severity: 16, Column %ls constraint for column ‘%.*ls’ references another column, table ‘%.*ls’.
Error: 8143, Severity: 16, Parameter ‘%.*ls’ was supplied multiple times.
Error: 8144, Severity: 16, Procedure or function %.*ls has too many arguments specified.
Error: 8145, Severity: 16, %.*ls is not a parameter for procedure %.*ls.
Error: 8146, Severity: 16, Procedure %.*ls has no parameters and arguments were supplied.
Error: 8147, Severity: 16, Could not create IDENTITY attribute on nullable column ‘%.*ls’, table ‘%.*ls’.
Error: 8148, Severity: 16, More than one column %ls constraint specified for column ‘%.*ls’, table ‘%.*ls’.

Error: 8149, Severity: 16, OLE Automation objects are not supported in fiber mode.
Error: 8150, Severity: 16, Multiple NULL constraints were specified for column ‘%.*ls’, table ‘%.*ls’.
Error: 8151, Severity: 16, Both a PRIMARY KEY and UNIQUE constraint have been defined for column ‘%.*ls’, table ‘%.*ls’. Only one is allowed.
Error: 8152, Severity: 16, String or binary data would be truncated.
Error: 8153, Severity: 10, Warning: Null value is eliminated by an aggregate or other SET operation.
Error: 8154, Severity: 15, The table ‘%.*ls’ is ambiguous.
Error: 8155, Severity: 15, No column name was specified for column %d of ‘%.*ls’.
Error: 8156, Severity: 15, The column ‘%.*ls’ was specified multiple times for ‘%.*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.

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 *