Answer / meenakshi

we can link database If both the DBs are on same Server and
the current user have access permission on both database
then you can use the following query..

Select SomeColumns From CurrentDBName..TableName
Select SomeColumns From OtherDBName..TableName

If the databases are on different Server then you have to
use the Linked Server..

EXEC sp_addlinkedserver @server = 'SERVER', @provider
= 'SQLOLEDB.1', @srvproduct = '', @provstr
= 'Privider=SQLOLEDB.1;Data Source=TargetServer;Initial
Catalog=Database'

go
Exec sp_addlinkedsrvlogin @rmtsrvname = 'SERVER', @useself
= true, @locallogin = null, @rmtuser = 'Userid',
@rmtpassword = 'Password'


On your SP you can use..

Select * From OpenQuery(MyRemoteServer, 'Select * From
Sysobjects')

--OR

Select * From MyRemoteServer.DatabaseName.dbo.Sysobjects

Answer / anil

You can also use curl function for use defferent database

Tell us something about heap tables?

0 Answers  

---

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

3 Answers   ABC,

---

Is mysql distributed?

0 Answers  

---

What are aggregate functions in mysql?

1 Answers  

---

What does "i_am_a_dummy flag" do in mysql?

0 Answers  

---

What are triggers mysql?

0 Answers  

---

How large can a mysql database become?

0 Answers  

---

How do I start mysql client?

0 Answers  

---

How to drop an existing view in mysql?

0 Answers  

---

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  

---

What is the difference between now() and current_date()?

0 Answers  

---

What is username in mysql?

0 Answers  

---