Hello... I am looking to see if it is possible to publish a subscriber... so i have the following: publisher -> distributor -> subscriber What I want is publisher -> distributor -> subscriber (now a publisher as well) -> distributor -> new subscriber Is this possible? Has anyone ha...more >>

I have a publisher that has worked for months. Now, two of the three subscriptions are getting errors: The process could not query row metadata at the subscriber. (source merge replication provider (agent): error number -217200996 General network error: check your network documentation I ...more >>

SQL 2005 Express SP1 pulling a merge replication from the command line using replmerg.exe from a SQL 2005 Std SP1 database, works great on our simple test databases. However, with the bigger more complex application we need to replicate (uses SP's, views, tables, etc.) we get the following ...more >>

We are using sql server 2005 and in our TEST environment --please note TEST-- I have set the subscription expiration interval to be 1 day. We made the mistake in the beginning of setting it to never expire and we are getting errors, performance problems etc. I am trying to test the behavio...more >>

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. -- ...more >>

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: Deletes of aged data in source datebase should n...more >>

Running SQL 2005/Win 2003 (publisher/distributor) & SQL 2000/Win 2003 (subscriber). Lat night around 6:30, 7 of my 15 subscriptions to one publication started to fail with the message below. I am not using merge anywhere, currently, though I have had a merge publication in the past that ...more >>

Can a Client Running a SQL Server 2005 Express Subscription replicate with another Client Running a SQL Server 2005 Express subscription? Or Synch with each other? Or do you still need a Std SQL Server in the backend to act as the Publisher/Distributor? If so do you still need CAL Licens...more >>

Hi All, 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???? Thanks in advance for the ...more >>

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. The subscription databases each run a cl...more >>

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...more >>

Hi Guys, 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 IDENT...more >>

Hi all, 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 th...more >>

By subscribing to a production server, will an impact be registered on the production server? If so, can I determine how large an impact? A good example for this question would be a view that includes orderlines. Would it be possible that the publication or subscription might lock the ord...more >>

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 ..Error ...more >>

Hi all, 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 around 30), running a mixture of SQL Server 2005 Express and SQL Server 2005. Now, I am...more >>

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 scheduled times during the day....more >>

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 replication first before distrubuting to the SQL S...more >>

Hi, 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 this...more >>