In Enterprise manager, 1)Right click on the table you wish to alter. 2)Right click and choose Design Table. 3)As soon as you make a change, a "Save Change script" Icon on the toolbar becomes active. This will allow you to save your changes to a text file. hth Gregg

http://www.codeproject.com/script/comments/forums.asp?msg=1002675&forumid=1725#xx1002675xx[^]

Gregg

Not sure what you mean, but have a look at the sp_executesql stored procedure. That may point you in the general direction

Gregg