SQL Server Performance Forum – Threads Archive
interchange databaseDear 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
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
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.