So I just found out that I really messed up!

I have managed to create several user defined data types and several tables in the same database with the same name.

I wanted to change the data type of one of my UDDT's and I found some strange behaviour. For one, If I rename the UDDT using EM, it actually renames my table!

Has anyone run into this before? How would I rename my UDDT's without causing big problems with my tables?

Thanks,

try to do it with a script in Query Analyzer. look in BOL for help on sp_rename; i thinl you need to specify the @objname parameter, and probably this is the mistake tha EM makes (in the back EM uses batch commands to accomplish stuff).

Thanks for the tip, but I have found a solution for my situation already.

I renamed the table with EM.
I then renamed the UDDT with EM.
I then renamed the table with EM (Back to the original name.)

This worked fine in my case, but it may not work for everyone because there are things that get lost / or break if you rename tables.

you found a quicker solution. nice.

i think this solution would work for more cases then you might expected, since i believe that nothing gets lost. the only problem is with batches or scripts that are running in the time interval when you do the renaming, and that reference the table.