-
Two databases
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
-
Two databases (reply)
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
-
Two databases (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|