BUG - Syncronising UDT change fails
adamjones
Posts: 5
I have made a change to the underlying data type of a UDT and I'm attempting to use SQL compare to create a change script.
The synchronisation fails with the following message:
On investigation it seems that the views which use the UDT are not being included in the sync, they're not listed on the 'Dependencies' page of the synchronization wizard (I have selected 'Include Dependencies'). The views also aren't shown in SQL server enterprise manager when I list the dependencies of the UDT, though I can't find any information to confirm that they're meant to be listed.
Any help with this issue would be greatly appreciated.
Regards,
Adam Jones
The synchronisation fails with the following message:
[15180] Cannot drop. The data type is being used.
The following SQL command caused the error:
sp_droptype N'AddressLine'
On investigation it seems that the views which use the UDT are not being included in the sync, they're not listed on the 'Dependencies' page of the synchronization wizard (I have selected 'Include Dependencies'). The views also aren't shown in SQL server enterprise manager when I list the dependencies of the UDT, though I can't find any information to confirm that they're meant to be listed.
Any help with this issue would be greatly appreciated.
Regards,
Adam Jones
Comments
I think we have addressed this and have a fix for it, but we don't want to release the fix to the public. I will email you a link to download the latest version and we'll see if that doesn't fix the issue in your case.