I want to keep a table as history and replace it with an empty one. How can I do this through Management Studio?
Don't have sql server around to test but I think it's just:
insert into newtable select * from oldtable;
select * into x_history from your_table_here; truncate table your_table_here;