Is it possible to query a database db1 from database db2 using stored procedures in db2. are there any kind of configuration settings that need to be implemented to do this.
Yes it is possible. If they are on the same server you can use fully qualified database.owner.table syntax. For example: select * from database1.dbo.customer
If they are on different servers you will have to probably look into linked servers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply