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 - 2004-10-22 : 07:29:34
|
| Harry writes "I want to get data to a program(VBA) by running a single stored procedure. But this s. procedure should give me data from other tables in other database, it is possible to do this? and How? I'll create a stored procedure in MS2000 database to run data from ADB database. I'll be grateful to get any sugestions.regardsHarry" |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2004-10-22 : 07:36:49
|
| Harry,This can be done using linked server.U can configure link server using "sp_addlinkedserver". Check BOL for more information.RegardsSachin |
 |
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
|
|
|
|
|
stored procedure querying two databases?