SQL Server Error Msg 21540 – You cannot drop a column defined as data type uniqueidentifier with the rowguidcol property because merge replication uses this column for tracking. To drop the column, you must first drop the table from all publications and subscriptions.

In this blog post, let’s learn about the error message “21540 – You cannot drop a column defined as data type uniqueidentifier with the rowguidcol property because merge replication uses this column for tracking. To drop the column, you must first drop the table from all publications and subscriptions.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21540 – You cannot drop a column defined as data type uniqueidentifier with the rowguidcol property because merge replication uses this column for tracking. To drop the column, you must first drop the table from all publications and subscriptions.

Reason for the Error

To be update soon…

Solution

To be update soon…