Category: SQL Server

Using NOT operator to inverse the condition in SQL Server

Imagine a scenario where you want to retreive records that you dont want. You can use the NOT operator to reverse the search condition. For example , You want to get all the departments having the GroupName other than ‘Research and Development’. The other way of getting the same result is using the != in every condition.

SQL Server Error Code – 47132 joining availability group ‘%.*ls’ with

In this blog post, you’ll learn more about the SQL Server Error Code 47132 and the error message description that is shown SQL Server Error Code 47132 SQL Server Error Description for the Code :47132 Joining availability group ‘%.*ls’ with rebuilding contained system DB has failed because rebuilding contained MSDB has failed. This is caused by contained MSDB is still used. Retry the operation later.

SQL Server Error Code – 9528 in the xml content that is supplied for

In this blog post, you’ll learn more about the SQL Server Error Code 9528 and the error message description that is shown SQL Server Error Code 9528 SQL Server Error Description for the Code :9528 In the XML content that is supplied for the column set ‘%.*ls’, the ‘%.*ls’ attribute on the element ‘%.*ls’ is not valid. The attribute is valid only for sparse columns…

SQL Server Error Code – 19479 the wsfc cluster network control api ret

In this blog post, you’ll learn more about the SQL Server Error Code 19479 and the error message description that is shown SQL Server Error Code 19479 SQL Server Error Description for the Code :19479 The WSFC cluster network control API returned error code %d. The WSFC service may not be running or may be inaccessible in its current state.  For information about this error…

SQL Server Error Code – 28074 service broker could not upgrade convers

In this blog post, you’ll learn more about the SQL Server Error Code 28074 and the error message description that is shown SQL Server Error Code 28074 SQL Server Error Description for the Code :28074 Service Broker could not upgrade conversation with conversation_handle ‘%ls’. Use END CONVERSATION … WITH CLEANUP to delete this conversation, then try again to enable the broker. Use ALTER DATABASE ……