this probably is not going to help you, but...

we had essentially two issues:

1)file permissions was related to permissions accessing the sqlce relay dll. for some reason we weren't authenticating properly,...

I just got back from the client's office. We got it solved!

It was a file system permission thing, so you were right on track. Wish I would have seen this...

Fantastic.

I will give that a whirl in the next couple of days (the server is in a production environment that I will not have access to for a couple...

Well, I fell pretty stupid here....

Sorry, the ID field is NOT a Primary Key. It was intended to be a primary key, but did not get created that way...

I might not quite be following what you need. Is it the publisher or the subscriber you are trying to drop?

But of course, at that point, it is usually something like...

Andy is quite p*ssed. Me is not!

This may or may not be the kosher way, but....

I've had similar issues using merge replication. You could try either of the following:

1) If you have a publication script, you...

I find that if you want the field to remain NULL you must explicitly assign NULL to the field. If you are passing an empty set it will save as...

Thank-you!

That's perfect.

Can't help with the re-initialisation (actually have the same problem myself and was hoping to find an answer here), however, to find out when the subscription expires...

In Enterprise Manager, expand...

I like Joseph Sack's book:

SQL Server 2000 Fast Answers for DBA's and Developers

ISBN 1-904347-09-6

I didn't think you could run SQL Server on XP Home.

you need to use join filters.

if you haven't solved the problem yet, post a reply and i'll through some stuff together.

Great! Thank-you both so much.

I should have thought of that, but.... can't know everything I guess.

dkehler