I am using SQL Server 2005 replication with anonymous subscriptions and web
synchronization. The server is SQL 2005 Standard and the subscribers are SQL
2005 Express. Every subscriber syncs with the publisher once an hour. There
are no re-publishers.

When recovering the subscriber in transactional replication (sql 2000) is the
subscriber database restored from the publisher (essentially setting it up
all over) or from the backup of the subscriber?>
Thanks.

I read the microsoft article about how to handle the identity column in
replication. There is sentence: " If you are using transactional replication
with the immediate-updating Subscribers option, do not use the IDENTITY NOT
FOR REPLICATION design." That means I can not use the ...

Hi, I would like to implement Transactional Replication in SQL Server 2005 to
meet requirement for reporting functionality. The idea is to replicate data
in a replica in which reporting will be perfomed. The following is additional
requirement:

I am seeting up a transactional replication where the subscriber database has
a lot of Historical data. When the distributor agent runs I get errors like
Cannot Insert duplicate key in objwct... Error number 2601.
Violation of UNIQUE KEY constraint ... Cannot insert duplicate key  ...

Hello All - When taking a snapshot of the database, what kind of lock is put
on the tables?  Can users write to the tables while the snapshot is happening?
Thanks,
Mitch

I have a merge replication on a SQL 2000 database to a remote site.
I have selected "publish all" in publication properties. Now if I  a new
table is created, does it automatically runs the snapshot agent and include
that table in to the table schema????

I am trying to replicate a database (sql server 2000) to a remote site. I
use merge replication and do almost continous replication.
My problem is I have one application which creates atleast 6 or 7 new tables
a day. Everytime it create a tables, snapshot agent restarts again and ...

Say in the future (2 weeks) that the database (replicated) will be upgraded
and/or tables will be added/amended what is the best way to do this.
For example, already one of the database tables needs to be dropped and
recreated with different fields!. Can I create a schema just for ...

I have 7 tables that I want to remove the checkbox for "Enforce relationship
for replication".  These tables are all articles in a publication and I want
them to get down to the merge synchronization laptop subscribers.  On a test
system, I unchecked them in EM and the changes ...

On the second screen in the wizard for configuring the distributor on SQL
2000, the correct server name has been used but the password is incorrect.  
There is no way to remove the server name thus no way to reenter the correct
password to the distribution database.  Help.

We have recently installed a new SQL Server 2005 box to compliment our
existing SQL Server  2000.  To ensure data consisitentcy we have
employed replication between the two servers.  We are using
transactional replication, with the replication being applied at

I am in need of some replication advice...
We have the following scenario:
Publisher running SQL Server 2005 with SP1
Multiple subscribers (at the minute, 10, but there will eventually be

Does SQL Server 2005 Express edition support Web based replication from one
Client Subscriber using SQL Server 2005 Express and another Client using SQL
Server 2005 Express?
Or do you have to have to setup a Full SQL Server 2005 and configure

I'm getting this error when I try to replicate
The schema script
'\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQL_L_060104_ZenithSQL_L_060104\20070120231902\tblCall_1.sch'
could not be propagated to the subscriber.  The step failed.