February 5, 2009 at 11:40 pm
Hi,
Can you explain me the different ways of how a database (Database1) in server (Srvr1) can be connected to a database (Database2) in server (Srvr2) using a query?
I have admin access to both databases mentioned above with valid credentials.
Thanks in advance.
"I Love Walking In The Rain So No One Can See Me Crying ! " ~ Charlie Chaplin
February 6, 2009 at 12:17 am
What are your tasks though? Is it just connecting to the database. Could you provide us with more info?
You can do this in many ways:
Linked server
Replication
Logshipping
DB Mirroring
Failover Cluster
But what is your objective though?
February 6, 2009 at 12:38 am
You can do it ... but should you ???
http://www.sqlservercentral.com/Forums/Topic639157-360-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 6, 2009 at 6:18 am
Hi,
You can use it by creating Linked server. Another way is openquery and opendatasource functions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply