Thanks for the great information. I am also new to replication and might need to get ramped up in a hurry so this was quite helpful.

I was curious on your opinion if my scenario would be an ideal candidate for replication. There is some old legacy data that needs to be cleaned up by some staff that are probably going to be at different locations that aren't connected. I was starting to look at the possibility of installing personal edition of SQL 2000 on their machines and then maybe doing replicating to keep the data as synchronized as possible. This seems like a good case for replication, but I am new to it so I thought I would get your take. thanks

Keith