• I could have done this... but my B server is a remote server, that don't accespt IMPORT db...

    Create a linked server on 1 of the machines then use a cross server query to pull out the data, something like

    select * into destinationdb.dbo.tablename from linkedservername.sourcedb.dbo.tablename

    thankx will try the other options too