sql2k sp3a I have about 20 Pull Subscriptions. How do I tell which ones, if any, are marked for re-initialization? TIA, ChrisR. ...more >>

Does replication allow object changes? I read that in SQL server 2000 it will update new columns on the Publisher and push them to the subscriber, but does that mean if create a new stored proc on the publisher it will push that as well to the subscriber? Thanks!...more >>

Win 2k / SQL 2K The SQL Server Agent on one of my servers is causing performance problems with other applications on the server. When I stop the SQL Server Agent, the applcation run fine. I have run sp_replshowcmds @maxtrans = 10000 on all published dBs and few if any transactions are displa...more >>

I am running SQL 2000 on a Win 2000 box. I have several tables that I are published(merge) to specific locations. I have a field in the table that designates the location (3,4,5,6...). Currently I have created a publication for each location, filtering each publication for the correct locat...more >>

sql2k sp3a Howdy all. In dev, I add an article by going to the publication props/ articles/ show unpub.../ check the table to add/ hit yes for the message. Then when I run the snapshot agent it only snapshots for that table. But in production, it wants to generate the snapshot for all tabl...more >>

Hi Is it possible to replicate just some records in a table and can the filter be implemented (I am trying to avoid a situation that employees will have the full version database while they are away from the office [they only need te records that are assigned to them]) Thank you, Shmuel S...more >>

I'm setting up log shipping on our production server to log ship to our reporting server. I choose standby mode, but everytime someone is in the secondary db log shipping fails. I thought by choosing standby mode the secondary database would still be accessible- was I wrong? If so, any way to ...more >>

Assume the following scenario: I have an existing publication using merge replication with ServerA as the distributor and publisher and ServerB as a push subscriber. I need to add ServerC as a push subscriber. In addition, the publication has been in service for several years, and I understand...more >>

When I create a pull subscription from my main database, I go through all the steps and successfully create a the subscription. However, when I drill down in the replication monitor on the publisher down to the database thats being published, the snapshot agent says it has succeded but has not...more >>

Hi All, Where will I get SQL 2005 JUNE CTP / Installation CD? Regards Raj ...more >>

Is this possible? How would I do it? Rob ...more >>

Transactional replication for failover - Microsoft describe this at http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx and include discussion of how to configure identity columns, with NOT FOR REPLICATION on the subscriber. However, http://www.replicationanswers.com/Tran...more >>

We are using anonymouse pull subscriptions over the internet. We are not using VPN. The physical SQL Server is called SQL22Server. We have a Domain assigned to it called something like company.com. However, I found that on the client machine, I had to put in a hosts entry to route SQL22...more >>

I'm currently using merge replication that is not syncing the data when applying the snapshot. When applying the snapshot, the only bcp files transfered are msmerge_contents.bcp, msmerge_genhistory.bcp, sysmergesubsetfilters.bcp and msmerge_tombstone.bcp. The problem is that the snapshot ag...more >>

I have two SQL servers (2000) A and B. 1. A is the production server and B is the back-up server. I would like to create a one-way merge replication from A to B so that the data is updated from A to B and not from B to A. I do not have any keys in my tables. Please give me all the steps ...more >>

Using Enterprise Manager I have run the Wizard to create a publisher on an MSDE database (with SP4 applied). The snapshot agent shows error details as "Line 59: Incorrect syntax near 'Contact'." Any ideas?...more >>

I see a strange problem in one of my table which is used in replication. This table has a text datatype column and some rows of it shows up as null while others have data, when replicated from production to another server. any thoughts or ideas why for some rows the data transferred is null when ...more >>

I think that the configuration for replication via VPN is the same as that used on a LAN. But I can not register remote SQLserver by name and it does not work by IP. 1. Does it work in case dynamic IP ? 2. Use alias name instead of IP address ? 3. Other recomendations . Please help. Thank y...more >>

We're using replicaiton merge between two servers over a very slow network connection. SQL Server SP3a on a win2k box. Replication was 'off' for about a week before our DBAs noticed. Now when the merge replication job is turned on it will only runs for about 1/2hr. After 1/2 hour the publicati...more >>

According to BOL in regards to "Validating Replicated Data": While the calculations are performed, shared locks are placed temporarily on tables for which rowcounts or checksums are being run, but the calculations are completed quickly and the shared locks removed, usually in a matter of se...more >>

I am looking for a replication solution that could support the following. Currently I am thinking that merge replication is the only possibility. (Sorry for the long list of requirements - seems to me like what I need is not the standard setup you read about in SQL Books!) Currently I have ...more >>

hello everyone. we're looking at implementing a new hot-backup sql server scenario, i'm trying to compare/contrast transactional replication versus database mirroring. first: i've read about a dozen or so threads in this newsgroup and found them all very informative (as always, thanks Hilary for...more >>

Is it always must to have truc. log on check point option turned off at Publisher database in Transactional Replication...??...more >>

Let me preface this post by saying that I am not a DBA, but have been tasked with some information gathering. When talking about SQL Server replication, a colleague of mine said that he has heard mixed emotions about it. He said, that some people say it works fine, yet others have big problems w...more >>

experiencing some very odd behavior in Enterprise Manager. I have a process that performs the following: 1.) Restores a published database from Server A onto Server B. The databases are identical and they are both published. 2.) I run a script that then deletes the subscriptions to...more >>

hi all, got a major problem, having done some mods to my replicated database, the subscriber, no has primary key violations. im using sql server identity range management so this should be fine, i have performed an table upgrade in this way before. scrpit out the repliation, remove the ...more >>

Hi, We're running sql2000 with transactional replication. I found that the system table distribution.msrepl_commands has over 3 million records. So, I execute the command "EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 0" manually. As the result, the no. of ...more >>

Hi, there I tried to replicate between the sql 2000 servers As you know, In order to try to set up the replication, I need a sql server name on the list box which is used to select the publisher and the subscriber. So I had tried to register SQL 2000 Server at the first time. but there is...more >>

Question: Is it possible to configure replication between two servers so that a publisher for one table is a subscriber for another one in the same database? Scenario below Server A <-----------------------------> Server B Table 1 --------------------------------> Table 1 (Replica) Table 2 (...more >>

Hi everyone. Two days ago I tried to replicate between the SQL 2000 Server and the Oracle 8i. Before the transaction replication, I had configured linked server for replication. (I suppose linked server's configuration is OK. When I queried using the Openquery, the result was no problem.)...more >>

Hi, Is it possible that a table which is member of a publication, be subscribed to a subscription to receive replicated data as well? I mean something like re-publishing. Any help would be greatly appreciated, Leila ...more >>

Hi, Short version: How do I set NOT FOR REPLICATION for foreign key constraints? Long version: I have run into a serious problem: In some tables, on which I have foreign key constraints defined, rows get deleted. I get conflicts (type 6, reason code 547). The reason text is: "The row was ...more >>

We are current running sql 2000 SP3. I have a database being replicated (Transactional) from server A to server B. When I switch the application to server B, I found all user table's primary are not set. What's wrong and how to fix it? Thanks. Joe...more >>

sql2k I need to do replication of a between 2 buildings 30 miles apart with 1 T1. I read about the nosyn method in http://support.microsoft.com/default.aspx?scid=kb;en-us;320499 but the hangup Im having with this is putting the DB into Single User Mode. I see the logic here, but this sucks...more >>

Hi, We have a SQL 2000 server, that is not setup as a distributor or a publisher. It is not involved in replication. We are seeing new connections on the server every 30 mins, from user NT AUTHORITY/SYSTEM application SQLDMO executing sp_helpdistpublisher @check_user = 1 a number of times. ...more >>

I'm trying to pull new subscription from another server, but for some reason my attemp fails. The error I get is Error 15004: Name cannot be NULL. Can someone tell me how can I resolve this issue. Thanks ...more >>

Hi, i restored a backup from a database thas has replication configured. When i restored it the system tables that the merge replication creates are restored too. I was investigating on internet and I found that i can delete it using this query: sp_configure 'allow updates', 1 go reconfigure...more >>

Does anyone know of a 3rd party product that is proven in providing HTTP replication for SQL2000? If not, has some ever done it using the MS provided features in the product or the .NET suite? Thanks. ...more >>

writing data to a text blob will not force a replication. We use the update method to write the data. Changes in text blobs in some tables force replication and some are not. What could cause this problem? The replication has been working without problems. What action could have caused ...more >>

I am implementing transactional replication which I tested with a selection of a few tables and all runs correctly, when testing I can see the transactions I enter replicate to the subscriber however when I select all the tables I want for replication the snapshot runs through and creates ta...more >>

Dear All, I have a database (with lots of data) that needs to be migrated to a merge replication setup. I already have the setup done (1 publisher, 2 subscribers) and enabled identity range management. I need to copy the existing data to one of the subscriber to let it propagate to the publ...more >>

i want to prevent some referential integrity scripts to be deployed at the subscriber *before* the snapshot is applied , is there a way to interfere with initial snapshot programmatically? thanks in advance ...more >>