I'm creating a stored procedure in SQL Server 2000, and in the stored procedure, I have no problem manipulating data in the database I'm in. However, I also need to access data from a completely different database on a completely different server. Can I do so in that same stored procedure?
(maybe using ADO? or maybe create another stored procedure in that 2nd DB and call it from the original stored procedure?--help!)