THANKS!

"Make sure you have Set NOCOUNT ON and SET ANSI_WARNINGS OFF."

After including these statements as first two rows in my stored procedure, i was finally able to access two different databases (select...