Copy two tables in MsSql

Do you know how to copy two tables in mssql 2000? It’s quite simple.

SELECT *
INTO master.dbo.micro_blog
FROM master.dbo.micro_blog