-SELECT * INTO DB2.dbo.RFmaster FROM ILS.db1.RFmaster
INSERT
TagUID
ItemTitle
MediaTypeCode
BranchCode
BibliographicCode
BibliographicRef
SortingCode
LocationCode
Tagstatus
Volume
SELECT
Advance thanks for the best reply.