Posted by Razvan Socol on 03/20/06 08:47

Hello,

Currently, this is not possible using a single statement. You can vote
for this suggestion here:
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=ed13e43a-a55a-45ee-98fb-b56f330a2cfa

In the meantime, you can use Enterprise Manager or Management Studio to
make this modification (which recreates the table and copies the data,
a pretty dangerous thing to do in a production environment). See:
http://www.aspfaq.com/show.asp?id=2528

Razvan

[Back to original message]