Category: SQL Server
SQL Server Error Code – 570 instead of triggers do not support direc
In this blog post, you’ll learn more about the SQL Server Error Code 570 and the error message description that is shown SQL Server Error Code 570 SQL Server Error Description for the Code :570 INSTEAD OF triggers do not support direct recursion. The trigger execution failed.
SQL Server Error Code – 5310 aggregates are not allowed in the values
In this blog post, you’ll learn more about the SQL Server Error Code 5310 and the error message description that is shown SQL Server Error Code 5310 SQL Server Error Description for the Code :5310 Aggregates are not allowed in the VALUES list of an INSERT statement.
SQL Server Error Code – 9504 errors and/or warnings occurred when pro
In this blog post, you’ll learn more about the SQL Server Error Code 9504 and the error message description that is shown SQL Server Error Code 9504 SQL Server Error Description for the Code :9504 Errors and/or warnings occurred when processing the XQuery statement for XML data type method ‘%.*ls’, invoked on column ‘%.*ls’, table ‘%.*ls’. See previous error messages for more details.
SQL Server Error Code – 13389 key name
In this blog post, you’ll learn more about the SQL Server Error Code 13389 and the error message description that is shown SQL Server Error Code 13389 SQL Server Error Description for the Code :13389 Key Name
SQL Server Error Code – 689 operation not allowed because of pending
In this blog post, you’ll learn more about the SQL Server Error Code 689 and the error message description that is shown SQL Server Error Code 689 SQL Server Error Description for the Code :689 Operation not allowed because of pending cleanup of online index build. Wait for cleanup to complete and re-run the operation.
SQL Server Error Code – 8379 old style raiserror (format: raiserror i
In this blog post, you’ll learn more about the SQL Server Error Code 8379 and the error message description that is shown SQL Server Error Code 8379 SQL Server Error Description for the Code :8379 Old style RAISERROR (Format: RAISERROR integer string) will be removed in the next version of SQL Server. Avoid using this in new development work, and plan to modify applications that…
SQL Server Error Code – 11262 a corrupted message has been received. t
In this blog post, you’ll learn more about the SQL Server Error Code 11262 and the error message description that is shown SQL Server Error Code 11262 SQL Server Error Description for the Code :11262 A corrupted message has been received. The destination certificate issuer name size is %d, however it must be no greater than %d bytes in length. This occurred in the message…
SQL Server Error Code – 16102 object name specified ‘%.*ls’ is not val
In this blog post, you’ll learn more about the SQL Server Error Code 16102 and the error message description that is shown SQL Server Error Code 16102 SQL Server Error Description for the Code :16102 Object name specified ‘%.*ls’ is not valid.
SQL Server Error Code – 33244 sql server audit failed to create an aud
In this blog post, you’ll learn more about the SQL Server Error Code 33244 and the error message description that is shown SQL Server Error Code 33244 SQL Server Error Description for the Code :33244 SQL Server Audit failed to create an audit file related to the audit ‘%s’ in the directory ‘%s’. Make sure that the disk is not full and that the SQL…
SQL Server Error Code – 40096 critical replication task could not star
In this blog post, you’ll learn more about the SQL Server Error Code 40096 and the error message description that is shown SQL Server Error Code 40096 SQL Server Error Description for the Code :40096 Critical replication task could not start. State is %d.
SQL Server Error Code – 41856 memory optimized file consistency error
In this blog post, you’ll learn more about the SQL Server Error Code 41856 and the error message description that is shown SQL Server Error Code 41856 SQL Server Error Description for the Code :41856 Memory optimized file consistency error detected. A file with FileId %.*ls of size %I64d bytes is smaller than expected %I64d bytes.
How to get the first character of a string in SQL Server ?
Assume a scenario where you have a column in your table in SQL Server database where you want to retreive the first character of the column value. How to get the first character of a string in SQL Server ? You can use the LEFT function and specify the column name as well as the number of characters from left that you want to retreive.
SQL Server Error Code – 5131 the log was not rebuilt because there is
In this blog post, you’ll learn more about the SQL Server Error Code 5131 and the error message description that is shown SQL Server Error Code 5131 SQL Server Error Description for the Code :5131 The log was not rebuilt because there is more than one log file.
SQL Server Error Code – 20511 updateable subscriptions: cannot update
In this blog post, you’ll learn more about the SQL Server Error Code 20511 and the error message description that is shown SQL Server Error Code 20511 SQL Server Error Description for the Code :20511 Updateable Subscriptions: Cannot update timestamp columns.
SQL Server Error Code – 6272 alter assembly failed because required p
In this blog post, you’ll learn more about the SQL Server Error Code 6272 and the error message description that is shown SQL Server Error Code 6272 SQL Server Error Description for the Code :6272 ALTER ASSEMBLY failed because required property ‘%s’ in type ‘%s’ was not found with the same signature in the updated assembly.
SQL Server Error Code – 8942 table error: object id %d, index id %d,
In this blog post, you’ll learn more about the SQL Server Error Code 8942 and the error message description that is shown SQL Server Error Code 8942 SQL Server Error Description for the Code :8942 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID. Test (%.*ls) failed. Slot %d, offset 0x%x overlaps with the prior…
SQL Server Error Code – 9803 invalid data for type “%ls”.
In this blog post, you’ll learn more about the SQL Server Error Code 9803 and the error message description that is shown SQL Server Error Code 9803 SQL Server Error Description for the Code :9803 Invalid data for type “%ls”.
SQL Server Error Code – 4829 cannot bulk load. error reading the dest
In this blog post, you’ll learn more about the SQL Server Error Code 4829 and the error message description that is shown SQL Server Error Code 4829 SQL Server Error Description for the Code :4829 Cannot bulk load. Error reading the destination table column name for source column %d in the format file “%s”.
SQL Server Error Code – 17829 a network error occurred while establish
In this blog post, you’ll learn more about the SQL Server Error Code 17829 and the error message description that is shown SQL Server Error Code 17829 SQL Server Error Description for the Code :17829 A network error occurred while establishing a connection; the connection has been closed.%.*ls
SQL Server Error Code – 27252 the integration services cluster worker
In this blog post, you’ll learn more about the SQL Server Error Code 27252 and the error message description that is shown SQL Server Error Code 27252 SQL Server Error Description for the Code :27252 The Integration Services cluster worker agent ‘%ls’ is disabled.