Category: SQL Server

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 – 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 – 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…

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 – 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…