Category: SQL Server

SQL Server Error Code – 26064 sql server could not listen on ip addres

In this blog post, you’ll learn more about the SQL Server Error Code 26064 and the error message description that is shown SQL Server Error Code 26064 SQL Server Error Description for the Code :26064 SQL Server could not listen on IP address [%s] because the cluster resource ‘%s’ is not online (state = %d). This is an informational message and may indicate that resource…

How to ALTER a Column from Null to NOT Null in SQL Server ?

Assume a scenario where you have a table that contains columns which are Nullable integer column. You might want to update them to NOT NULL column (adding NOT NULL constraint) and set its value to zero. How to ALTER a Column from Null to NOT Null in SQL Server ? This would be a two step process where you should first update the column values…

SQL Server Error Code – 41329 unsupported operation following a transa

In this blog post, you’ll learn more about the SQL Server Error Code 41329 and the error message description that is shown SQL Server Error Code 41329 SQL Server Error Description for the Code :41329 Unsupported operation following a transaction dependency failure. Parameters and variables cannot be accessed in the CATCH block and the CATCH block must raise an exception following a dependency failure.

SQL Server Error Code – 1465 database ?%.*ls? database is not in full

In this blog post, you’ll learn more about the SQL Server Error Code 1465 and the error message description that is shown SQL Server Error Code 1465 SQL Server Error Description for the Code :1465 Database ?%.*ls? database is not in full recovery mode on each of the server instances. The full recovery model is required for a database to participate in database mirroring or…

SQL Server Error Code – 7888 the ipv6 address specified is not suppor

In this blog post, you’ll learn more about the SQL Server Error Code 7888 and the error message description that is shown SQL Server Error Code 7888 SQL Server Error Description for the Code :7888 The IPv6 address specified is not supported.  The server may not be configured to allow for IPv6 connectivity, or the address may not be in a recognized IPv6 format.

SQL Server Error Code – 18786 the specified publication does not allow

In this blog post, you’ll learn more about the SQL Server Error Code 18786 and the error message description that is shown SQL Server Error Code 18786 SQL Server Error Description for the Code :18786 The specified publication does not allow subscriptions to be initialized from a backup. To allow initialization from a backup, use sp_changepublication: set ‘allow_initialize_from_backup’ to ‘true’.