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 is mysql57?

0 Answers  

---

What is delimiter in mysql trigger?

0 Answers  

---

Write a query to select all teams that won either 1, 3, 5 or 7 games.

0 Answers  

---

How many rows we can insert in a mysql table?

0 Answers  

---

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  

---

How to check server status with 'mysqladmin'?

0 Answers  

---

What does mysql flush tables do?

0 Answers  

---

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

0 Answers  

---

Do I need python for mysql?

0 Answers  

---

What ascii 31?

0 Answers  

---

What are the advantages of mysql in comparison to oracle?

0 Answers  

---

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---