none
How to alter a User Defined Data Type used on primary keys RRS feed

  • Question

  • I have an SQL 2005 server and I am trying to modify to UDT varchar length from 20 to 30 and they are used in Primary Keys.

    I found some nice code on http://www.sql-server-performance.com/faq/How_to_alter_a%20_UDDT_p1.aspx

    but it does not work with primary keys as Allow null as been switched to true.

    I have tried to look at the Profiler trace when updating from the Visual Studio 2010 Data Schema compare but I would like to have a nice clean stored proc I could create and call.

    Thanks in advance

     

     

    • Edited by MarcoB Friday, January 28, 2011 4:00 PM syntax error in title
    • Moved by Esther FanMicrosoft employee Friday, January 28, 2011 7:28 PM (From:Visual Studio 2010 Visualization & Modeling Tools)
    Friday, January 28, 2011 3:59 PM

Answers