Are these users DDL Admin?

Yes, I have heard cases where things has gone wrong. The SPs can have new functionality, deprecate some commands and this can cause havoc to your application that was running...

There is another thread who had almost the same error. Paul Randall helped the OP out. Check this thread.

You can use Bi-Directional replication, Immediate or Queued updating subscription.

Try catching the error in the SP.

First you test the SP in a test server. Then only do you apply it in production. You do not trust any patches from anyone blindly.

Also it would be...

If you post this question in SQL 2005 Administration forum, you will get better response. I am no Mirror expert.

Not enough info in your question to give a perfect answer, but you can look at Filters in replication. You can also modify the replication system SPs to suit your...

Did you set up the replication using RMO or Windows Synchronizing manager? Please keep in mind that SQL Server Express does not have a SQL Server Agent. There for the...

What do you mean by "Someone already set up replication in Server A"? If someone sets up replication, they should have a Distributor and a subscriber. So which is the...

Great, Please do let us know if that was helpful to you. There are couple of others who are facing the same issue.

Did you try the ddl_admin role ?

Try adding the user to the TargetServerROle in MSDB. That should give them access

If you are using SP3 or above of SQL 2000, you have to add the user to the TargetServerRole in MSDB so that they can view the status of the...

If you want the latest data, the best would be to use transactional replication to another server where the users can run their reports. If you do not mind if...