On SQL Server 2000, how do you (nicely) get a copy of the Read-Only
destination database?
The only way I've figured out is to stop SQL Server, copy the MDF & LDF,
restart SQL Server, then attach those newly copied files.  But isn't there a

DearAll,
I applied the modifications by implimenting the joins,created indexes
on relevent columns which are  acting as optimizer hints-result positve
improvement in the query processing,apart from that there is one more

Transaction replication with read only subscriber.
Publisher - SQL server 2000
Subscriber - SQL server 2000 entrp
Following err noticed in Distribution agent history

SQL server 2000
replication - Tran with read only subsriber
When i run Validate subscriptions on publication i see error as below :
SQL server enterprise manager could not validate subscriptions.

 I'm still fairly new to replication on SQL Server 2000, but, I'm
quickly learning (trial by fire).  I have a database that has a
publication with six subscribers.  A couple of the tables have their
identity ranges auto-managed (the IDENTITY column in each of the tables

I would like to start the agents every 30 secs as opposed to the current
continuos mode for our SQL 2000 transactional replication setup.
Time and again, we have our log reader and distib agents timing out and then
after 10 attempts they fail and then we have to manually go and ...

We have a few replicated accounts, all have been using SQL 2000.  One
of the clients the other day decided to upgrade their SQL server
without telling us, hence our replication stopped.  I tried to get a
client connection to their server but was unsuccessful.  Is there a

We are using Web Synchronization against a Republisher topology...  Meaning
we are using load balanced IIS servers against republishers.  Right now Each
IIS server has a dedicated republisher pointing to a central server, not
across a WAN though.  Our goal was mainly to create a ...

I've written a custom conflict resolver in the form of a stored procedure and
applied it as the resolver for a particular article in my merge replication.  
This stored procedure is failing because the subscriber is not in sysservers.
I use the 4 part name to look at subscriber ...

We have an sql server (server A) at a supplier that is windows 2003,
running sql server 2000.  Its only connection to the outside world is
via normal internet access as any other pc there.
Now, at our facility here (which is completely separate from theirs) we

For my learning purposes, I'd like to generate a conflict in MSSQL2K5 Merge
replication. How would I make this happen?
TIA, ChrisR

I am replicating 78 tables from a master database for a scale-out solution.  
My dilemma relates to best design practices – I have found only one article
about design considerations for publications and this guy recommended
creating multiple publications within a single database ...

We are receiving an error when the distribution agent executes the generated
stored procedure sp_MSupd_PointOfSales.  The bit flag for the identity column
is not set and the identity column is Yes (Not For Replication).
The sp_MSupd_PointOfSales stored procedure checks to see if ...

I want to create subscriptions for my visual basic programme. I want to
subscribe both the
PULL and PUSH subscriptions for my applications from the Server
I am able to create the PULL subscription from my application but I

Dear All, I am facing a problem with the following query,taking lot of
time to fetch the data,
calling the data using multi selects.
CREATE proc Rolexi36Sync