getting data from two databases 2

[shaminda]

I have a database (say database1). In this database I have a stored procedure (say sp1). The stored procedure selects data from a table (say table1). Instead of selecting data from table1 database1, I want to select the data from table2 database2. But the stored procedure will be in database1. Is this feasible? If it is how do I do it? Any help will be appreciated.

 

[tlbroadbent]

Use DBName will not work in a stored proceure. Using the three part table name will work.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Vinodk]

Use a three part name like database.owner.objectName to fully qualify the table to access.

eg. Select * from NorthWind.dbo.Customers

HTH,
Vinod Kumar

 

[shaminda]

I got it working using database2.dbo.table2. Thank you all for your help and fast response.