Hi all
i could use a bit help im not exactly an expert in MS Sql 2k but i know a bit and can find my way around (i think)
My scenario:
I have a database which i want to share between the sales personal.
I have 1 server with the "host" database
and 10 or more in sale, who need access to this database when they are in the company but they also need to be able to type info into the database when offline out at the customers and then when they return his/her's database are replicated with the Host database so both parties get the new information that has been typed.
Ive been trying to have a master and a local database on 2 machines but i cant get the master to push the table i created down to the subscriber.
Can this at all be done, and if i hope you can help
Jesper
i could use a bit help im not exactly an expert in MS Sql 2k but i know a bit and can find my way around (i think)
My scenario:
I have a database which i want to share between the sales personal.
I have 1 server with the "host" database
and 10 or more in sale, who need access to this database when they are in the company but they also need to be able to type info into the database when offline out at the customers and then when they return his/her's database are replicated with the Host database so both parties get the new information that has been typed.
Ive been trying to have a master and a local database on 2 machines but i cant get the master to push the table i created down to the subscriber.
Can this at all be done, and if i hope you can help
Jesper