This will copy a table, structure and data from SQL server database to another.
Damn handy!
SQL:
- SELECT * INTO TargetDatabase.dbo.MyTable
- FROM SourceDatabase.dbo.MyTable
Handy SQL Server script
Reply