Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gargmanoj
Starting Member
7 Posts |
 Posted - 2005-08-09 : 01:00:40
|
| Hi all,How can i setup a distributed database in MS Sql Server 2000?I am having three m/c all having sql server2000. My requirements are such that user of the datbase should not be aware of distributed datbase i.e. it should be transparant to the user. user will fire a query and he will be given back results. its urgent plz respond..thanx in advance. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-09 : 10:47:15
|
| not sure exactly what you are looking for but you might want replication. this can be simple or very complex depending on your requirements.====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-09 : 17:27:33
|
What is a "m/c"?quote:
Originally posted by gargmanoj...I am having three m/c all having sql server2000...
CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-09 : 17:35:10
|
| I think he is asking about partitioning a table across servers.m/c stands for micro-computer, which would be a server in this case.I think this is a homework question though as he's a student according to his web site.Tara |
|
|
|
|
|
|
Howt o setup disrtribute database in MS Sql Server