Ну так из примера IMHO все-таки видна суть

create table DataBase1..test (id int primary key, name varchar(20))

insert into DataBase1..test values (1,'name_1')
insert into DataBase1..test values (2,'name_2')
insert into DataBase1..test values (3,'name_3')
insert into DataBase1..test values (4,'name_4')


select * into DataBase2..test from DataBase1..test
select * from DataBase2..test

PS
BOL - Creating and Maintaining Databases - Stored Procedures - Creating a Stored Procedure - Programming Stored Procedures - Qualifying Names Inside Stored Procedures