Make sure all of latest sql service packs are installed.

Change your isolation-level to read-uncommitted for ALL select statements at subscriber.

You can do SET ISOLATION LEVEL READ-UNCOMMITTED (see bol) at top of each sp - or - in from clause...

You don't need to drop & recreate - on publisher, right click on subscription and select re-init.

YOu will need to run you snapshot agent for this pub. Don't run in...

need just a little more info to get help from the group.

version? os? service packs? dedicated distributor? trans/snap/merge/peer? what are you doing to get this error? is error on snapshot/distribution/logreader...

You're right - mirroring not an option in 2000.

I would look at using a dedicated distributor server since your vendor app is transaction intensive.

You have a choice to go with...

No. SQL2000 replication objects are to be installed from SQL2000 install CD on your SQL2000 db server.

cb

You can use the derived column transformation to add the columns to your text file upload downstream, then use the lookup trans to populate your new columns...

Regards,

ChrisB MCDBA

MSSQLConsulting.com

Of course the 2 are compatible. They are included with 2005. If you have a 2005 license you get both these add-ons at no additional cost, but really these are...

distributor must be as close as possible to publisher.

as far as 3 million transactions - you can consider testing to measure latency. the best way with replication is to let...

I assume the log reader is getting blocked by a reindex job. As far as purge, if you are purging millions of records - watch your distributor - can it...

Only by dropping subscriptions will it be removed from repl mon. Set your timeout to unlimited or to a high value for merge agent.

ChrisB MCDBA

MSSQLConsulting.com

I have never been able to add an article with the GUI when there is an active subscription. I will test Suresh's post.

You can do in script:

exec sp_addarticle @publication =...

Spaces shouldn't be a problem. What exactly is the problem, are you seeing errors?

ChrisB MCDBA

MSSQLConsulting.com

Mirroring is not an option to offload reporting. The mirror db is in an offline status.

Log shipping is a possible solution, since the db can be left in a standby...

There are replication components that need to be installed when you install SQL2000. Try to re-install from CD.

ChrisB MCDBA

MSSQLConsulting.com