Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-13 : 21:50:45
|
Lorenzo writes "Hi there,
I'm pretty new to the stored procs, and my question is probably a simple one but I couldn't find any answer here, so...
I have 4 different databases, and I'd like to use one stored proc (located in a 5th one) to query three different tables in each, and group the result in one output only (don't ask me why, the reason is : poor data modeling from the beginning.)
Is that possible, or am I obliged to duplicate my stored proc in each one of the 4 databases (which would severely reduce the benefit of using stored procs in the first place) ?
Thanks for your time, sorry for my poor english too.
Bye
Platform:
Windows NT OS Version 4.0, Service Pack 6
SQL Server 7.00.623" |
|
|
|
|
|
Using stored procs through multiple db