I think the answer is that only transactions can span several databases -
stored procedures cannot. But I hope someone will prove me wrong...

Set

>Hi list,
>
>I've got two or more databases which are fully the same in design but have
>different data. And each database I got stored procedures which are
>generating reports. Now I want to get consolidated reports from these
>databases.
>
>So what is the best way to do this? I tried to use connect statement in my
>procedures but could not succeeded.