Then he doesn't have SA level rights based on his NT login.

Andy

Have not had to so far. I could see trying to throttle the full text some, but I dont think I'd change the priority for SQL. Could be wrong! One...

How about just using DTS to move the data?

Andy

Not a lot, depending on what you want I guess! I've done restores of both published and subscribed db's lots of times with no problem. When you restore a db...

Log Explorer by Lumigent is probably your only shot.

Andy

Nope, but a guess would be something related to sp_getapplock?

Andy

In SQL2K scope_identity solves the @@identity problem.

Andy

I think there is another cleanup proc. Dont have it handy, you might try searching the site for merge replication. Will try to look later.

Andy

Sounds like you have auto stats turned off? If you dont want stats updated automatically then you need a job to do it periodically (or remember to do it after...

Steve is busy this week - when he gets back will have to see if he has any ideas. Does seem awfully bizarre! The problem, not Steve having ideas.

Andy

If you detach/reattach there will be no change in the current identity value. @@Identity is only going to return a value if you have just inserted a record.

Andy

One thing I see is no 'exit sub' right before your error handler label. Also, shouldnt you be using a try/catch block instead of on error resume next?

Andy

If he has it operating in mixed mode he should have had to set an SA password. Either way, have him enter a sql login/password for you, then use Query...

I'll have to look, working on a deadline at work so it may be a day or two! You should check the verbose setting of your repl agents, maybe set...

He just needs to connect with an NT login that has sufficent rights to change SQL's security settings. See if he has an administrator account on the machine, or domain...