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

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

0 Answers  

---

How can you add and remove any column of a table?

0 Answers  

---

How to create trigger in mysql workbench?

0 Answers  

---

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

0 Answers  

---

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

0 Answers  

---

Is mysql a free database?

0 Answers  

---

How do you flush privileges?

0 Answers  

---

What is max_used_connections in mysql?

0 Answers  

---

How to get data from mysql in php?

0 Answers  

---

What is RMS Migrations

0 Answers   Steria,

---

In which language it is written?

0 Answers  

---

What do you understand by mysql terminal?

0 Answers  

---