Hi,

One way to solve this is to be a little clearer with your post LOL....:)

I'm not sure what you have done and at what point you are getting a failure.

Can...

Hi,

Don't worry about this...it was a bad idea....didn't pursue it..

Thanks

graeme

Hi,

Surely the push is going from the publisher therefore once this is disabled the subscriber no longer receives the snapshot data..or am I missing something ??

Graeme

Hi,

The only time this has happened is when we have applied a no synch snapshot. We synch the data manually with the rowguids I might add as they are...

Hi,

Does this mean that sometimes it works. Once you've applied the snapshot, the merge agent will manage the records. Have you changed the identity ranges at all ??

Thanks

Graeme

Hi,

When I set up my replication I simply change the name of the job in EM. To something a little more meaningful.

The only thing you have to watch out for...

That is correct.

The only time a complete snapshot is created is when you reinitialize the subscriber...in this case you are not

Glad to help

Graeme

Yeah..did that..

I actually reinstalled SQL server 🙁

I could uninstall, so I had to manually remove sql server..but even after a total reinstall it still shows as 6.5

Very strange

Graeme

Hi,

What sort of errors are you getting ?

ARe all the indexes in place ?

Do you have a lot of data waiting to be replicated ?

Thanks

Graeme

Use procedures to do this.

Drop the subscribers to the Article...sp_Dropsubscribers..is that the one ?

Drop the Article from the publication...sp_DropArticle..

G

Hi,

Not sure what you are getting at here.

Replication has its varied uses, what do you want to use it for. There is no point in configuring it if you only...

Oh..to add, to will lose data entered at the subscriber while the table is dropped. But then you would only do this when there were no changes being made.

G

With the newer versions of SQL this is very simple, you can use ALTER commands while the table is replicated. Unfortunately for SQL 2000, one way is to drop the...

Creating indexes does not use an ALTER Table statement so you should be fine.

Graeme

Hi,

If I remember correctly, you can only do this if there is no subscriber.

Regards

Graeme