What's the easiest scripted way to completely remove replication? I've seen this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;324401 ....but what I'd really like to find is a script that goes on a search and destroy mission for replication related stuff (tables, data in ...more >>

I was just wondering what are the precautions I should take when trying to replicate fk's. I know one thing, is that the pk table should be in the same publication. Also, default constraints should have no problems, right? Pk constraints also should have no problems, if I am correct. On ...more >>

Should this work? In production we have one server acting as the publisher/distributer, and then another as the subscriber. In the test environment, I'd like to have all of this on the same server. Will this work? I've run into what I hope is a minor gotcha (running the drop replication scr...more >>

Hi Gang, Does anyone know how to createa a new subscription using RMO on SQL Server 2005. I'm using the beta version (Sep CTP) but SQL books online has bad links on the doc's for doing this. Any help will be greately appreciated, Thanks, --Ader. ...more >>

I've configured SQL 2005 Beta (SepCTP) for web synchronization and I had the webservice (replisapi.dll) configured correctly. However after a reboot, I only get "Service Unavailable" I reviewed the configuration and have run the "Cinfigure Web Synchronization..." wizard but I haven't been abl...more >>

Hey all, I have a handheld SQLCE merge replication going. Thanks MS for this technology! It's working out great. I have 3 handhelds setup with this merge replication. All is working well but I need to add a new table to this logic where all the handhelds push their data into, but do not ...more >>

Hello I read a post in the newsgroup about replication and logshipping. I wanted to clarify further. We have a warm-standby server to our production server. We use logshipping to keep the stand-by in sync. Now we want to setup anothere server for reporting as the current standby cannot...more >>

Hi All I had stopped transactional replication for about 5 hours and now i have restarted it. The replication is so slow. How can i calculate how many transactions are left to be replicated? Both the log reader and distribution agent are running although at times they time out.. I have trie...more >>

Hey. I've setup a publication with some tables who have clustered as well as non-clustered indexes. I dont want the non-clustered indexes to get transferred over. There r no subscriptions yet for this publication. I need to uncheck the NonClustered checkbox under the Snapshot Tab of Default ...more >>

Hi, I have very simple one way transactional replication. There are multiple publications. Every publication has multiple articles. All data in tables have been published without a filter condition. Recently i have been getting compalints about data sync. Changes appliad at publisher are not b...more >>

I had a problem and lost, with no backups, a couple of data bases. When I was recreating the subscriptions, a subscription just appeared the name is 'ServerName:database' & the type is 'Pull:shared agent'. I cannot delete the publication, I get the message 'SQL Server Enterprise Manager could n...more >>

Hi, I've a little problem in my sanpshot replication. I triy to replicate a db in a new server, everythig works fine expect one stored procedure. This store procedure, when replicated, generate the error number: 207 - "Invalid column name 'SELECT c.CliID AS ID_Client, '." This is a simple s...more >>

I am getting the following error: SQL Server does not exist or access denied. Error number 17. The publication and distributor is SQL Server 7.0 from internal lan. The subscriber is SQL Server 2000 from external wan outside of the firewall. Using SQL Server Enterprise Manager 7.0 on the publ...more >>

hello, I'm unclear about certain aspects of replication and maybe somebody can help. I have sql 2000 servers all aroound and currently running transaction replication to replicate a database to a reporting server. If I add a table to the publisher and modify the piblication to include the n...more >>

Dear Friends we are having mearge replication between two domains. Now our policy for the SA is changed and we do not use the SA account anymore for the replication. As we have changed the password for the SA now the replication is failed with the follwoing error. The process could not ...more >>

Hi, i have this situation: I have a VB script that does a rollover of my website to production (pushes web site files to the right server, etc.) and as part of doing it it needs to also push a set of sql tables' data from one server to another. i can either do this with snapshot replication o...more >>

Hi All I have a transactional replication with one publisher/distributor and one subscriber. I want to add one more subscriber for another location. What is the best method to add one more subscriber? Expect expert's suggestions. Regards, Aris ...more >>

Hi, I am using a SQL server table in my Java application. I want to prevent reseeding of the identity column. Table T1: C1 INT IDENTITY NOT FOR REPLICATION PRIMARY KEY, C2 VARCHAR(100) Say I have values: 1, 'abc' 2, 'xyz' I can explicitly insert a value for C1 into this table by : SE...more >>

Hey guys. I want to implement merge replication and I know I've to implement dynamic filters based on user logins (suser_sname()). Anyways, the problem comes in here: I've to create a publication based on username where the users who login with certain usernames will point only to their row...more >>

I´m sorry, my english us very bad, so i try to explain my problem Hy, when i try syncronize SQL SERVER CE x SQL SERVER 2000, this message "Initializing SQL Server Reconciler has failed. [,,,,,]"...shows up in pocket pc application (csharp).. Anyone knows how can i fix this ? Thank´s ...more >>

Hey. I have transactional replications etup on 3 tables of a db. These tables have 181 million, 95 million and 100K rows respectively. They are rplicated using Transactional Replication, one way only. We have filegroups created for index and secondary files for data created on the publisher. O...more >>

When is Hilary Cotter's merge replication book going to be published? ...more >>

Hope somebody can help because this is rather fustrating. I have recently been doing some replication configurations between two servers. I started to get a warning symbol on the replication monitor so I decided to uninstall replication and start again. Unfortunately when I reinstall replicati...more >>

Hi All! I want to know if a DB on SQL 2005 can be subscribed to a SQL Server 2000 DB. Will it works fine? Also let me know any documentation about the SQL 2005 Replication. Thanks and Regards. ...more >>

Hi all, When we right click a replication agent, we can see error details tab. But in some cases the tab is disabled and in some cases it is enabled.I'm curious to know under what circumstances it is disabled and under what circumstances it is enabled. Thanks in advance, Preeths. ...more >>

Hi all, We have 2 merge replication jobs. I want to complete one job and then start another job after the first one is completed. Is there any way, that I can make the first job to trigger the second job as soon as it is over? Thanks in advance. Thanks, Preeths. ...more >>

Used the Wizard to Creat Publication for the first time. I saw three choices "Snapshot publication", "Transacional publication" and "Merge publication". I wanted to slect "Transacional publication" but it was grayed out. I wonder why!! Created a database with one table on server A. Cre...more >>

I need help, replication error The process could not execute 'sp_repldone/sp_replcounters' Thanks Carlo Sorrel ...more >>

Hi everybody, How can i add a field in a table which is involved in a Transactional replication. Thanks, MAtthew...more >>

I have a merge replication setup. Some time back i removed a table from subscriber which was in replication . I have included the table in replication again. How to synchronise the data in this table? I can not use sp_addtabletocontents/sp_mergedummyupdate because not only the data is hu...more >>

Some of the sp's used by replication to do insert/delete/update are = missing in the database being replicated to. If I reinitialize the snapshot will the missing sp's be generated? Do you have any idea as to why the tables (Schema & Data) were setup = during the snapshot but some of the sp's ...more >>

Hi All, I am a newbie to MS SQL Server 2000 but I really need to solve this issue: We need to daily replicate all databases within our MS SQL Server 2000 to another MS SQL Server 2000 - the amount of databases is not fixed because new databases are created on a daily basis. --> Is it pos...more >>

This may seem like a trivial question, but what's the point in allowing merge subscriptions to expire. True, the time can be set on expiration, but nonetheless, you may have PocketPCs out in the field for an indeterminate amount of time. I'm just wondering why in the first place you would EVER...more >>

Hi Guys, I have been playing with dynamic filtering in merge replication and I have a question about its behavior. What I have done is to use a user defined function to evaluate SUSER_SNAME() and return a list of ids by which the records should be filtered for that user. Every...more >>

I am trying to set up replication from a remote server (YYYY) to a server (XXXX) on my company's network. The remote server will be the publisher and the local server will be the distributor and subscriber. It gives me the following error when I configure the publisher and distributor : SQ...more >>

For a snapshot replication. I set the Name conflicts from the defualt-DROP the existing tables and re-create it to Delete All data in the existing table. and set check in Include declared refertial integrity in Copy objects to destination secton. After I close these perperties window and...more >>

After the initial snapshot had applied manually and snapshot agency stoped. Then I deleted the tables and stored procedure at subscription databse. I restart synchronizing, Sometimes the distribution agent moves the snapshot from the distribution database to the destination tables ; Someti...more >>

Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional database, DB2 also on Server A derived from DB1. Since the DB1 is frequently updated the synch...more >>

How can I replicate SharePoint Site to other SharePoint Site? Does SharePoint Portal Services support replication between two sites? Any help is much appreciated. Thanks...more >>

I restored a db to a new server, executed the following; exec sp_removedbreplication 'ADAGE' go exec sp_dboption 'ADAGE', 'published', 'FALSE' go exec sp_dboption 'ADAGE', 'merge publish', 'FALSE' go Yet, the ADAGE db still has views like sync% Did I miss a step necessary to remove a...more >>

SQL 2000 When changes are made to stored procedures at the publisher, the changes are not replicated to the subscribers. I have verified that the stored procedures are marked for replication. The end result is that users of the data on the publisher see different data than users of the dat...more >>

Greetings: Does anyone know if I can install/run the Log Shipping Monitor Utility on SQL 2000 Standard Edition, or do I need to actually have THREE copies of SQL Enterprise Edition in order to configure Log Shipping? I realize the recommendation is to NOT install the monitor utility on the ...more >>

Hi I'm in the process of working out how we are going to set up replication for a client. Quite a daunting task. I'm think we are going to use Bidirectional Transactional Replication, as described here: http://support.microsoft.com/default.aspx?scid=820675 If you look at the sample you w...more >>

Hi All As we know since SP3, the login security password are not even stored in the registry when using WSM. I saw that when adding the SubscriberEncryptedPasswordBinary in the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions\my_subscriptio n] WSM ...more >>

I need to copy an installation to another server without breaking merge replication on the existing database. Is the best approach to simply script out the database, do an export of the data, then recreate on the other end and set up a new publication? ...more >>

I have set up Merge Replication and everything is fine until a subscriber goes offline for any length of time. The issue has to do with the setting of the @identity_range parameter for each article. I am configuring the publication through the SQL Management Studio (server is SQL 2005) and ...more >>

Hi Guys - I have some basic questions about horizontal filtering and would appreciate any help. Dynimic Filtering When I create a snapshot of a publication that has dynamic filtering, what will it include? In other words, when the subscriber synchronizes for the first time, w...more >>

we have set up merge rep and it is working fine. i have setup alerts if rep fails. recently i am not getting these alerts what would be the reason how to configure alerts...more >>

Dear all, I want to add a new server as a publisher to an existing distributor, but each time I try, I get this error: Could not find stored procedure 'dbo.sp_MS_replication_installed'. I also tried making this machine it's own distributor, but the same error comes up. :( Thanks in adv...more >>

If my replicating db has an .mdf/.ndf/.ldf, with some tables being = located on the Secondary Data File, should I change the schema of the = replicated database to match the replicating db? Does it matter? Would it be a 'best practice' to have both database = schemas the same? I didn't set...more >>