Hi I am getting a timeout expired error on a transactional replication distribution agent. how do I go about figuring out what is wrong. I can select from the subscriber while in the publisher database, so does that mean the connection is OK. help thanks al...more >>

Okay I posted this yesterday I believe: “Let's say TableA on a 2000 ServerA.DatabaseA has an identity key and I want to transactionally replicate that TableA to a ServerB.DatabaseA (that is also 2000). But here's the catch: in the case of a significant outage on ServerA I want to be abl...more >>

We currently have a SQL2000 replication in place and we're considering moving one of the servers to SQL2005 x64. is 2000/2005 replication interoperable?. is the x64 2005 different in handling replication or is it interoperable with 32bit versions?(be it 2005 x64 to 2005 32b or 2000 32b) tha...more >>

I create the subscription table manually using the IDENTITY property and the NOT FOR REPLICATION option. I set the 'name conflicts article' property to 'keep the existing table unchanged' (Actually they are blank tables no any records in the tables). The question is after data are transfer...more >>

Can I use DISTRIB.EXE or REPLMERG.EXE to force SQL Express to synchronize a Pull Subscription on the SQL Express machine to the publisher (SQL Server)? ...more >>

I am currently trying to implement a replication strategy between n-many SQL Server 2000 databases, located on our hosting companies machine, and our reporting/datawarehouse server, located here in the office. So, I have 2 versions of SQL, Connection over the internet and 2 different domains ...more >>

Hello everybody, I cannot set my server as a distributor. It keeps telling me "SQL Server Agent on 'My Server Name ' currently uses the system account, Which causes replication between servers to fail. In the following dialog box specify another account for the Service startup account". I u...more >>

We have a SQL2000 Publisher, and SQL2005 server doing Distribution and Subscription. We're using transactional replication with push subscription. We've had this running reliably for 2 weeks with one publication with 21 articles. The database is a Great Plains DB for our UK office. We cre...more >>

Hey guys. I went to the Agent history for the distribution agent and it tells me 'A total of 1 transaction(s) with 8 command(s) were delivered.' Can someone tell me how I can check what was exactly done at this transaction? I need to know this because I just want to see wut it updated. Th...more >>

Hi all, my application (with sql server 2000) used transactional replication with several publishers and one subscriber. Because the subscriber could have its own data, when creating subscription I chose the "The subscriber has already schema and data" option, skipping initial snaphot from be...more >>

Hey. I've a few transactional publications. It fails with this error. When I looked at the command, it's trying to insert a null in identity column. Why does it do that? As of now, I've commented the update for the identity column in the sp_msupd_logdevicebeacon. But now, if somebody tries to ...more >>

I have a situation where I have SQL Server 2005 as my Publisher/Distributor and I have it setup to run Push Merge Replication. The subscriber is an instance of SQL Server Express. Obviously SQL Server Express doesn't have the means to force synchronization. I do have it setup at the moment ...more >>

Hello, SQL Server verison on Publisher: 8.00.970 SQL Server verison on Subscriber: 8.00.970 An update proc containing two statements was issued on the subscriber. The queue reader reports ODBC Error: Invalid cursor state. I do not believe that Q831997 Applies here, because the symptoms p...more >>

Hi all, got this error and well want some advice really. Cheers The process could not enumerate changes at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147200999) --------------------------------------------------------------------------------------------------...more >>

Let's say TableA on a 2000 ServerA.DatabaseA has an identity key and I want to transactionally replicate that TableA to a ServerB.DatabaseA (that is also 2000). But here's the catch: in the case of a significant outage on ServerA I want to be able to repoint the web to ServerB.DatabaseA and ...more >>

Hi I have transactional replication on my server. If I need to restart the Agent or Sql Server is there anything I should be aware of or is there a set way to restart sql server or the agent. If I restart Sql Server while a transaction is going on will there be any corruption or will Sql Serve...more >>

Hi, We have about 50 databases (SQL Server 2000, SP3) which are merge replicated. We merge replicate about 100 odd tables in each of these database. We need to add couple of columns in one of our major transaction table where most insert/updates are being done. This table presently on averag...more >>