Options
Bug: Applying dropped defaults to UDTs after they're dropped
sstephenson
Posts: 2
We have a UDT called ConnectionUser_udt defined as varchar(64). It is used twice each in 131 tables.
We had a default on ConnectionUser_udt called ConnectionUser_df defined as SYSTEM_USER(). We dropped ConnectionUser_df.
SqlCompare correctly unbinds the dropped default on ConnectionUser_udt in all the 131 tables. Then it drops the ConnectionUser_df default as expected.
However, after it drops ConnectionUser_df, it then tries to re-bind the default it just dropped back to ConnectionUser_udt.
SqlCompare should not reapply a dropped default.
We had a default on ConnectionUser_udt called ConnectionUser_df defined as SYSTEM_USER(). We dropped ConnectionUser_df.
SqlCompare correctly unbinds the dropped default on ConnectionUser_udt in all the 131 tables. Then it drops the ConnectionUser_df default as expected.
However, after it drops ConnectionUser_df, it then tries to re-bind the default it just dropped back to ConnectionUser_udt.
SqlCompare should not reapply a dropped default.
DROP DEFAULT [dbo].[ConnectionUser_df] GO ... EXEC sp_bindefault N'[dbo].[ConnectionUser_df]', N'[dbo].[ConnectionUser_udt]', futureonly GO
