Category: SQL Server

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

AbundantCode 1 year ago in SQL Server 0

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 ?

AbundantCode 1 year ago in SQL Server 0

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

AbundantCode 1 year ago in SQL Server 0

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.