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 |
|
pantamit
Starting Member
2 Posts |
 Posted - 2007-04-22 : 05:38:41
|
| We have developed a report in Crystal Reports 9.0 using stored procedure. Our reports is required to query two databases (db1 and db2). The SP we have developed at the moment assumed that both the databases are on the same server, but at the production environment this is not the case. The architecture looks like this Server 1 - db1Server 2 - db2 We need to re-write the Stored Procedure , such that it is able to pick up the records from both the databases at the same time. We also need to remember that the servers will be in Windows authentication mode only. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-22 : 05:47:32
|
you can use linked server to do this. Create linked server on one of the server to the other. And access the database using [server_name].[db_name].dbo.[table_name]
KH |
 |
|
|
pantamit
Starting Member
2 Posts |
Posted - 2007-04-22 : 06:26:53
|
| Hi,Thanks for the help. But there could be limitations with the linked server as well. The business has defined architecture that does not allow the usage of linked server. We need some other solution |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-22 : 10:19:14
|
So what is allowed ?
KH |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-22 : 17:49:00
|
| Put copy of one db on another server, say db1 on server2, if possible. |
|
|
|
|
|
|
Accessing two databases hosted on different server