Category: SQL Server

SQL Server Error Code – 21504 cleanup of merge meta data at republishe

In this blog post, you’ll learn more about the SQL Server Error Code 21504 and the error message description that is shown SQL Server Error Code 21504 SQL Server Error Description for the Code :21504 Cleanup of merge meta data at republisher ‘%s’.’%s’ could not be performed because merge processes are propagating changes to the republisher. All subscriptions to this republisher must be reinitialized.

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.