To create a 'backup' of a table in the same database
first create the schema (bak) then generate the sql script:
SELECT
'select * into bak.'
+
name
+
' from dbo.'
+
name
FROM
sysobjects
WHERE
xtype
=
'U'