What are the challenges you face when working across database platforms? Take the survey

BUG - Syncronising UDT change fails

adamjonesadamjones Posts: 5
edited October 4, 2006 12:56PM in SQL Compare Previous Versions
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:
[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.


Adam Jones


Sign In or Register to comment.