Category: SQL Server

SQL Server Error Code – 21806 the agent profile creation process canno

In this blog post, you’ll learn more about the SQL Server Error Code 21806 and the error message description that is shown SQL Server Error Code 21806 SQL Server Error Description for the Code :21806 The agent profile creation process cannot validate the specified agent parameter value: the profile_id %d does not exist or it does not support the parameter %s. The value must be…

SQL Server Error Code – 33075 granular auditing is not available in th

In this blog post, you’ll learn more about the SQL Server Error Code 33075 and the error message description that is shown SQL Server Error Code 33075 SQL Server Error Description for the Code :33075 Granular auditing is not available in this edition of SQL Server. For more information about feature support in the editions of SQL Server, see SQL Server Books Online.

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…