Answer Posted / 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

What is the difference between unix timestamps and mysql timestamps?

951

---

What mysql means?

886

---

write a command to view the content of the table

857

---

What are procedures in mysql?

886

---

What are triggers mysql?

841

---

Does mysql use t sql?

917

---

How to check if value already exists in mysql database in php?

825

---

What is the difference between mysql_connect and mysqli_connect?

906

---

What is difference between mysql and mysql server?

932

---

Is sql and mysql same?

871

---

What is the use of concat() in mysql?

931

---

What are mysql data types?

941

---

How do we delete a row in a table?

920

---

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

932

---

What is msql?

914

---