If you had this problem from the beginning then I would deffinitely look at the agent profiles first.

Modifying the profiles can especially help if you are connecting to the subscriber via a...

Azam,

Are you getting this error in the initial merge repl configuration?

I have seen this error as well. Try increasing the query time-out in the agent profile, decreasing the number of...

Well, this is a complete shot in the dark.,,

But, is it possible that value may be driven off of your merge agent profile? There is a value in there...

Couple of questions:

Was this working previously and failing now?

Is your distrutor server the same as your publisher server?

Is it possible a service account expired and the publisher is unable to contact the...

Michelle,

Are Foreign key relationships being being enforced for replicatino in your repl config? 

Also, is this transactional or merge?

I think we need some more info for this one.

Have you tried pinging the DNS name to see if there is actually another virtual server with that name? 

Try going into the Repl Monitor-->Agents and find the agent that coreponds with the publication you are having trouble with. (not sure if you are running transactional or snapshot repl)

Right...

Thanks for the feedback.

Are you saying this includes a situation where the data is all in one file and the indexes are all in another file?

Hi Al,

Have you tried searching the cluster for isqlw.exe.

Once you find the kick off exe, work backwards on why you are not able to start it.

Not sure but I am thinking it is because the transaction has not committed yet and won't see the value until it is committed ( the I in ACID

Bueller? Bueller? Anyone?

I am thinking now that whatever permissions you set on the Server Level User it over-rides the DB level permissions and propogates down.

Can...

Sorry you need the server components.

But you should be able to install Developer Edition to a work station. Do you know what edition you are trying  to install?

Yeah, I had read about that tool some. I will play around with it on my machine and see about installing it on the server. Thanks.

I know another way...

As Kathi stated, the reason for failure is that the script checks to make sure users do not own objects in the DB before it tries to drop them but...

Hi Kathi,

Thanks for the feedback.

Another question for you:

The SQL job is set through EM to quit on failure. If the script throws an error when dropping the users wouldn't this...