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
Sharjah
UAE

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
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>