It is good to have the option on to generate scripts anyway (however much you like/dislike the SQL produced) - as this reminds you that you should have scripted!

Pity the option is so weirdly hidden in Enterprise Manager - what were they thinking.

For those reading this thread who are unaware of this option - you can set SQL Enterprise Manager to always prompt you to save a change script when you change an object through the GUI - only way I have found to set this on in the GUI is make a change to an object (e.g. a table) and while you are doing it there is a little icon in the tool bar that looks like a scroll with a floppy disk in front of it - clicking this allows you to create a change script and on the bottom of the save script box there is a tick box to "Automatically generate change script on every save" - tick that and in future you will be presented with a create change option every time you change something (you can always answer no to the script option if you don't want one in future - but the reminder will be there).

For those happy with RegEdit the option actually ends up in

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Datatools as AutoSaveChangeScript dword 1 = do 0 = don't

Take the likes below into a text file - give it a .reg extension and you have a .reg file you can apply wherever you want this set:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Datatools]

"AutoSaveChangeScript"=dword:00000001