Select and insert problems...

[worldchanger]

I have two databases, A and B. I'm trying to do a select from database A table a1 and insert that into database B table b1. What do I need to do to make this happen? Is it possible?

 

[JamesLean]

USE dbB
GO

INSERT b1 (col1)
SELECT col1
FROM dbA.dbo.a1

--James

 

[worldchanger]

That worked ;-) Thanks!!!