Thats not bad. But wouldnt success or failure in this case just indicate if the job started ok, rather than the job itself completed ok?

Andy

Thanks for joining in Rick. We appreciate the comments!

Andy

I just put up a review of a product called Data Compare, might be worth looking at for this problem. It does a field by field compare, with a few...

Pretty interesting. I dont use the master server functionality at work, only have two boxes, hardly worth while. But anyway...

If the target subscriber has (or could have) access to the...

Paul, I think I see your point - where I work the lines blur a little too, and it wouldnt be out of the question for me to need to...

Sounds like maybe the replication set up failed? You should have triggers on all the subscribed tables, I'd look for those first. If they are present, then you have to...

Take a look at the EMPTYFILE option for ShrinkFile. I think that is the right way to get the data out without resorting to things like changing your clustered key.

Andy

...

I'd say risk the performance problem and deal with it when it happens.

Andy

I dont use them heavily, but I do use them, never had an issue so far.

Andy

What kind of issues Steve?

Andy

Yes. You just use the inserted table to qualify which rows you want to update.

Andy

Sure. Assuming you're using ADO, just do something like this:

cn.execute "whatever sp"

Then start polling.

Andy

Probably the easiest way is to detach the database, then copy it to the other machine and reattach. Take a look at sp_detach and sp_attach in books online. In SQL2K...

You're going to pay for doing the constant update - I don't have the experience with that to say for sure, but I doubt dedicating processors is a good idea....

Kowabunga, someone who likes to compile code!

Andy