interchange database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

interchange database

Dear All,
my question is i wrote a stored procedure in one database called ‘usa_sales’, in that SP i am get some data from another database called ‘ind_sales’. Can any one tell me how to do this?
Thanks & Regards
Thanesh Peer Thanesh
Unique System
Select columns from ind_sales.dbo.table Madhivanan Failing to plan is Planning to fail
If the both the databases are on the same server you can use three partname which is dbname.schemaname.objectname…
If the databases are on different servers then use four part name which linkedServerName.databasename.schemaname.objectname
Microsoft SQL Server MVP
Moderator All postings are provided “AS IS” with no warranties for accuracy.