• Just to spell it out, EM will "convert" the table by creating a new table, copying over the data, dropping the old table, and renaming the new table to the old table's name.

    In the "design table" EM interface there's a toolbar button (third from the left in my current configuration) that's title "Save Change Script"; make your changes in the interface, click on this, and you get the script. (Profiler works too, but then you get all the EM connection setup and communications chaff as well.) Note also that this script tends not to be particularly efficient, and you might want to review it for large databases. (I personally suspect it's backwards compatible with SQL Server 6.5)

    Philip