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

How many rows can be inserted in mysql at a time?

1058

---

What are the 'mysql' command line options?

1048

---

What is sql vs mysql?

1069

---

How do you say mysql?

957

---

Is mysql from oracle?

1013

---

What is row level locking in access?

934

---

What is a scalar function?

1041

---

What is row level locking?

989

---

What is offset limit?

1003

---

What is the difference between unix timestamps and mysql timestamps?

1059

---

How do I create a mysql database?

971

---

Where is mysql used?

1033

---

How do I start and stop mysql server?

1026

---

How to define numeric 9(3) in db2 table without decimal point??

2901

---

How do I find mysql database?

951

---