Hi, I am having a problem decieding if using Immediating updating subscribers is the best thing to use in my situation and would appreciate comments about it. I have four database servers located around the local area. (A,B,C,D) server A stores a global inventory count as well as the se...more >>

Some of the subscribing tables are out of sync with the publisher and is there a way to just reinitialise those tables instead of the whole subscription, I am using SQL 2000 Thanks ...more >>

When I validate ( sql server 2k ) a subscription (exec dbo.sp_table_validation @table = 'outmail_', @expected_rowcount = 7, @expected_checksum = -2564394433, @rowcount_only = 2, @full_or_fast = 0, @shutdown_agent = 0) I get the following error - ' does not exist . Could the problem relate ...more >>

Hi, I have two servers named Sql1 and Sql2. Transactional replication without immediate or queued updating is implemented on Sql1. Sql1 is publishing our commerce database. Looks like all but 3 tables are being published. A pull subscribtion is set up on sql2. I get this error when ...more >>

Hi I would like to know if there's an easy way of copying 4 database from a development server to a demo server. My first try was to detach and then to copy the database. This takes a while and the people want to continue to use the databases for testing. Next I tried to replicate the datab...more >>

I have 2 servers Server A and Server B. I am trying to setup a merge replication between the two servers. But when I tried to Push Subscription from Server A, after sometime it fails with error: "The process could not deliver the snapshot to the Subscriber." The account & password inf...more >>

Hi, I am running merge and transaction replication on 2 SQL Server 2000 servers. All was working fine until a DMZ was installed on the distributor server. Now the merge replication still works, but the transaction replication errors every time, cannot connect to distributor. I can p...more >>

We are running SQL 2000 SPK2 with Internet Replication for remote users (MSDE 2000 SPK2)- the complete a merge replication. The are not constantley connected and use either dialup or ADSL VPN connection. Basically the are people on the road carrying around product info and collecting small...more >>

Reading about transactional replication and want to kno why an update is converted to a delete and insert Please explain Thanks ...more >>

Hello, I am new to replication but have successfully setup a transactional replication of a database. However a DTS package that I have for the database fails when I run it. It is failing on a step that runs a stored procedure that clears data from a subset of tables. The procedure drops ind...more >>

Hello, While generating Intial snapshot all scripts are keeping SET Quoted_Identifiers ON where my default setting is OFF and I want to keep it OFF...How can I do it for Replication. Thanks Nilay...more >>

I am replicating between 2 sql server 2k systems. I have copied the logins and passworks between the two systems. Next I created a login syncroniztion DTS package; the final step is an sp_resolve-logins execute sql task : sp_resolve_logins 'isis', '\\a10i2d1\D$\MSSQL$I2D1 \repldata','syslogin...more >>

I am receiving a message in the "Job History" for a pull subscription after trying to "Start Synchronizing" It states: Merge Replicator Provider Number -2147201001 "\\ ... \tblInventory_1.sch" could not be propogated to the subscriber. The step failed." I have defined a Merge Publicat...more >>

Error message The process could not bulk copy out of table '[dbo]. [Traxis_SID_VEHNAME_VIEW]'. Error detail I/O error while writing BCP data-file (Source: ODBC SQL Server Driver (ODBC); Error number: 0) ...more >>

Hello Group, I have 2 servers in my office. One in US and one in India. Both Servers have same database. I want the 2 Servers to be in Synch. Insert/Update/Delete happen in both servers. Can anyone suggest me the method to approach to accomplish this setup. I am trying 2 way trans...more >>

I had update triger setup on one of the subscription table.The problem is that when I run an update on the published table replication is never updating the records on the subscription table. Instead of the update it is doing a delete and an insert. Can some one guide me as to what setting...more >>

Hi, Does anybody know how to get enterprise manager to stop putting lines like setuser('taylorb') in the output .sql file when you ask it to script a whole load of stored procedures? I had even created a VB program to remove these lines but it isn't working properly now, and I thought it w...more >>

sql2k sp3 I just set up replication between 2 boxes. Initially all I had done was the initial setup: Ran the Configure Pub, Sub, Dist Wizard. That was all I had done. Red x's immediately showed up all over the place with no error messages in the right pane. The Log is of no help. I hadnt ...more >>

I'm having a problem with identity columns in merge replication. I have everything set up correctly and replication is actually working. The problem is that I haven't connected to the databases for about a week and a half and when I tried to run my app against the subscriber database tod...more >>

How can I alter a trigger on the table which is a publication in Snapshot replication. SQL 2K ...more >>

When I try to make a replication to my SQL Server I get this error when the process try to pushing data from publisher to subscriber. The merge process could not initialize the Publisher 'XXXXX:YYYYY'. The merge process could not initialize the Publisher 'XXXXX:YYYYY'. (Source: Merge R...more >>

About once a week the Log Reader Agent on our transactional replication just stops. I enabled logging but all it says is "Disconnecting from Publisher '<ServerName>'". I've increased the retry attempts on the run agent step but that didn't help. Does anybody know why it's doing this? I...more >>

Hi Client is using merge replication. At the subscriber, the sa password has changed. Now the subscription is unable to synchronise. How do I get the merge agent to recognise this. Thanks ...more >>

Hello, I have a problem creating merge replication for a database which has "non dbo owned" tables. Those tables have identity columns, so I choose to use automatic identity range handling. Setup: 1 PC with MSSQL Server 2000 SP3a Server login "test_user" in a role of sysadmin. 2 databases...more >>

I am setting up replication for a central database with several sites. I have set up a pull subscription on the first site and have it working properly (at least I think so) so I would like to script it out and use the script at the other sites which will have an identical setup to the fi...more >>

Getting the message ------------------------ SQL Server Enterprise Manager successfully created a pull subscription to publication 'Publication_TJJTest'. The initial snapshot for publication 'Publication_TJJTest' is not available. This subscription will be initialized after the snapshot ...more >>

I am running SQL 2000 on a Win 2000 box on all servers. I have several remote SQL servers that all have PUSH subscriptions to the main office. If I modify any of the sp_MSins_TABLE-NAME stored procedures at the main office, will it ever be recreated without my modifications?? Like if I ...more >>

I have a number of users who will be synching on dialups, nominally 56K but often significantly slower because of poor dialup connection in the local areas they stay overnight in (tend to be rural). Ergo I like the idea of the Slow Connection profile for the merge agent, but I am concerne...more >>

Hi, I would like to keep an exact copy of a client table on a server, and always keep it updated. What is the best way of doing this? I have a production pc with msde logging 60B of production data every 5 mins. Data is kept in a Current-table for the current batch and copied to the main se...more >>

I am trying to set up a replicated database for reporting purposes only. We are running SQL Server 2000 SP3 on Windows Advanced Server SP3. What I am needing is a guide to help me set up the entire replication process. I ahve set up the Distributor and created a publication but I can not get...more >>

i am facing a problem in merge replication . I have successfully set up a publication at remote server (Sql Server 2000)and a subscriber at client side (Sql Server 2000 running on Windows 2000 Prof) 1)When i start Synchronization through Enterprises manager following errors occur: ...more >>

Is is possible to have a one subscription database, receiving changes from 2 publication databases with transactional replication? Thanks, MT...more >>

Hello, I'm getting the following error on the subscriber when replicating data. Please help! 18052 : Error: 3624, Severity: 20, State: 1. 17066 : SQL Server Assertion: File: <recbase.cpp>, line=1378 Failed Assertion = 'm_offBeginVar < m_SizeRec'. ERROR LOG: 2...more >>

1)How to view objects information storing in database physical files .MDF and .LDF ? 2)If I have this two files , How to restore to a database. Thanks!...more >>

Hi friends, How to take backup & restore replicated db (publisher & subscriber both)? ...more >>

I'm supporting 4 SQL Servers with a fairly complex merge replication schema. One replication, "WebMerge", published on the "LongHorn" server, publishes 10 tables and has two push subscriptions, 1 to the server "SouthernStar" and 1 to the server "McCoy". One table, "SubDivisions", in the ...more >>

Hi, Windows 2000/ SQLserver 2000 sp3 i want to put fulltext search for my reports. so i tried the fulltext search testing on my test server. the Mssearch is taking 90% Cpu. So i dont want to put the search service in my production box. I want to move the data to report server using T...more >>

Noob question: I do not have a list of the names of the computers in use among my intended pull-method subscribers, and in any case they were not named consistently or meaningfully. On the other hand, I haven't distributed MSDE2000 out to them yet, so I can fully control their SQL login ...more >>

Hello, We are making a Transactional Replication with DTS transformation. We tried to use Lookups in the DTS package and the result is "Variable is undefined: 'DTSLookups'". (We use 'Option Explicit', otherwise it would be 'Type Mismatch: 'DTSLookups'). This problem has been described many ...more >>

Is there a way of telling if replication is turned on for a particular database using TSQL?...more >>