SQL Server Errors or Failures from Error: 8056 to Error: 8113
Error: 8056, Severity: 16, The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter %d (“%.*ls”), row %I64d, column %d: Data type 0x%02X (user-defined table type) has too many optional metadata tokens specified.
Error: 8057, Severity: 16, Table-valued parameter %d (“%.*ls”), row %I64d, column %d: Data type 0x%02X (user-defined table type). The specified column is computed or default and has ordering or uniqueness set. Ordering and uniqueness can only be set on columns that have client su
Error: 8058, Severity: 16, The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter %d, to a parameterized string has no table type defined.
Error: 8059, Severity: 16, The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter “%.*ls”, to a parameterized string has no table type defined.
Error: 8060, Severity: 16, The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter %d (“%.*ls”), row %I64d, column %d: Data type 0x%02X (user-defined table type) is null and not set to default. A null table-valued par
Error: 8061, Severity: 16, The data for table-valued parameter “%.*ls” doesn’t conform to the table type of the parameter.
Error: 8062, Severity: 16, The data for the table-valued parameter %d doesn’t conform to the table type of the parameter.
Error: 8063, Severity: 16, The incoming tabular data stream (TDS) remote procedure call stream is sending an unlimited length CLR type. Parameter %d (“%.*ls”) is defined as type %.*ls. This type is not supported by down-level clients. Send the serialized data of the large CLR type
Error: 8064, Severity: 16, Parameter %d ([%.*ls].[%.*ls].[%.*ls]): The CLR type does not exist or you do not have permissions to access it.
Error: 8101, Severity: 16, An explicit value for the identity column in table ‘%.*ls’ can only be specified when a column list is used and IDENTITY_INSERT is ON.
Error: 8102, Severity: 16, Cannot update identity column ‘%.*ls’.
Error: 8105, Severity: 16, ‘%.*ls’ is not a user table. Cannot perform SET operation.
Error: 8106, Severity: 16, Table ‘%.*ls’ does not have the identity property. Cannot perform SET operation.
Error: 8107, Severity: 16, IDENTITY_INSERT is already ON for table ‘%.*ls.%.*ls.%.*ls’. Cannot perform SET operation for table ‘%.*ls’.
Error: 8108, Severity: 16, Cannot add identity column, using the SELECT INTO statement, to table ‘%.*ls’, which already has column ‘%.*ls’ that inherits the identity property.
Error: 8109, Severity: 16, Attempting to add multiple identity columns to table ‘%.*ls’ using the SELECT INTO statement.
Error: 8110, Severity: 16, Cannot add multiple PRIMARY KEY constraints to table ‘%.*ls’.
Error: 8111, Severity: 16, Cannot define PRIMARY KEY constraint on nullable column in table ‘%.*ls’.
Error: 8112, Severity: 16, Cannot add more than one clustered index for constraints on table ‘%.*ls’.
Error: 8113, Severity: 16, Incorrect use of the XML data type method ‘%.*ls’. A mutator method is expected in this context.
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.