Category: SQL Server

SQL Server Error Code – 25635 an attempt was made to add an asynchrono

In this blog post, you’ll learn more about the SQL Server Error Code 25635 and the error message description that is shown SQL Server Error Code 25635 SQL Server Error Description for the Code :25635 An attempt was made to add an asynchronous target to a session with a maximum memory of 0. For asynchronous targets to be added to a session, the session must…

SQL Server Error Code – 28006 user does not have permission to %s_msg

In this blog post, you’ll learn more about the SQL Server Error Code 28006 and the error message description that is shown SQL Server Error Code 28006 SQL Server Error Description for the Code :28006 User does not have permission to %S_MSG the conversation ‘%.*ls’ in state ‘%.*ls’. Only members of the sysadmin fixed server role and the db_owner fixed database role have this permission.

SQL Server Error Code – 3966 transaction is rolled back when accessin

In this blog post, you’ll learn more about the SQL Server Error Code 3966 and the error message description that is shown SQL Server Error Code 3966 SQL Server Error Description for the Code :3966 Transaction is rolled back when accessing version store. It was earlier marked as victim when the version store was shrunk due to insufficient space in tempdb. This transaction was marked…

SQL Server Error Code – 4073 a return value of data type varchar(max)

In this blog post, you’ll learn more about the SQL Server Error Code 4073 and the error message description that is shown SQL Server Error Code 4073 SQL Server Error Description for the Code :4073 A return value of data type varchar(max), nvarchar(max), varbinary(max), XML or other large object type can not be returned to client driver versions earlier than SQL Server 2005.  Please resubmit…