Two databases

[Manoj Kayastha]

Dear friends,

I have two databses in one MS SQL SERVER. I have to manipulate data from one database to another. In other words, I have to create the view or store procedure referecce the tables of other database. How ?

Thanks

best regards

manoj

[RickD]

Look up Linked Servers or sp_addlinkedserver in BoL.

Rick

------------
Manoj Kayastha at 7/11/01 6:35:18 AM

Dear friends,

I have two databses in one MS SQL SERVER. I have to manipulate data from one database to another. In other words, I have to create the view or store procedure referecce the tables of other database. How ?

Thanks

best regards

manoj

[Patrick]

For instance in a Select when you write the "from' to unumerate the tables you plan to use, give more detailled table name containing
for the same table 'Roysched' in two databases "pubs" and "pubs2 on the same server (your situation)
the "from" would reference
from pubs..roysched , pubs2..roysched
between the database name and the table name would appear the database owner.

Hope this help.
Patrick


------------
Manoj Kayastha at 7/11/01 6:35:18 AM

Dear friends,

I have two databses in one MS SQL SERVER. I have to manipulate data from one database to another. In other words, I have to create the view or store procedure referecce the tables of other database. How ?

Thanks

best regards

manoj