We are having problems with SQL Comparison due to the UDTs we have in our database. When the Block is executed, we get the following error:
Cannot drop type 'dbo.ShapeCollection' because it is currently in use.
This occurs in the following Batch:
DROP TYPE [dbo].[ShapeCollection]
All constraints and columns referencing the UDT need to be dropped before the UDT is being dropped. This is obviously not occurring.
Is there something I can do to get SQL Compare to generate a script that will successfully drop the UDT?