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.

Thanks.


[Non-text portions of this message have been removed]