Category: SQL Server

SQL Server Error Code – 21801 the stored procedure sp_createagentparam

In this blog post, you’ll learn more about the SQL Server Error Code 21801 and the error message description that is shown SQL Server Error Code 21801 SQL Server Error Description for the Code :21801 The stored procedure sp_createagentparameter failed to add one or more parameters to the system table msdb.dbo.MSagentparameterlist. Check for any errors returned by sp_createagentparameter and errors returned by SQL Server during…

SQL Server Error Code – 41853 memory optimized segment table consisten

In this blog post, you’ll learn more about the SQL Server Error Code 41853 and the error message description that is shown SQL Server Error Code 41853 SQL Server Error Description for the Code :41853 Memory optimized segment table consistency error detected. Current segment goes backward further than the definition record of the N-2 segment. Older Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin =…

SQL Server Error Code – 8037 the incoming tabular data stream (tds) r

In this blog post, you’ll learn more about the SQL Server Error Code 8037 and the error message description that is shown SQL Server Error Code 8037 SQL Server Error Description for the Code :8037 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 has an invalid data length…

SQL Server Error Code – 8678 cannot create the clustered index “%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 8678 and the error message description that is shown SQL Server Error Code 8678 SQL Server Error Description for the Code :8678 Cannot create the clustered index “%.*ls” on view “%.*ls” because the view references a SUM aggregate of a nullable expression. Consider adding a new COUNT_BIG aggregate over such nullable expression.

SQL Server Error Code – 21390 warning: only subscribers running sql se

In this blog post, you’ll learn more about the SQL Server Error Code 21390 and the error message description that is shown SQL Server Error Code 21390 SQL Server Error Description for the Code :21390 Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because extended properties are scripted out with the article schema creation script.