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