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

What are MySQL transactions?

2 Answers  

---

How do you determine the location of mysql data directory?

0 Answers  

---

How to concatenate two character strings?

0 Answers  

---

Can I use mariadb instead of mysql?

0 Answers  

---

Explain the difference between delete and truncate.

0 Answers  

---

how to declare unique key in creating a table..?

2 Answers  

---

What is dbms in mysql?

0 Answers  

---

What is the purpose of mysql database?

0 Answers  

---

What are the advantages of myisam over innodb?

0 Answers  

---

What is sql vs mysql?

0 Answers  

---

Can we store pdf files in mysql?

0 Answers  

---

Is sql and mysql same?

0 Answers  

---