In Oracle there is CREATE TABLE...AS to backup table into a new table and the syntax on SQL Server is a bit different to copy table. So the syntax on SQL Server is SELECT * INTO newtable FROM sourcetable Additional documentation from Microsoft http://msdn.microsoft.com/en-us/library/ms190750.aspx