I was trying to figure out if I can create an .sql file that uses different databases on the same server and run it in Query Analyzer.

For instance, I have two database, A and B.

The way I have to do it now is via DTS and export data from A to B.

I was trying something like the following, but couldn't get it to work:

Select * INTO B.dbo.Table from A.dbo.Table

Am I stuck using DTS for situations like this?