Wednesday, March 7, 2012

copying a table

Hi,o

I found an option to copy a table without having to script the table, now I can't find it. Is there an option to do this? When I selected the option, it didn't work. Any ideas? Also how do you turn off trace and statistics?

thx,

Kat

select * into newtable from old table

dbcc traceoff

No comments:

Post a Comment