I use merge replication on a SQL 2000 SP4 with dynamic row filtering. It has been working fine for years. This was the filter query: SELECT <Publizierte_Spalten> FROM [dbo].[Benutzer] WHERE [Benutzer].Hostname = HOST_NAME() Now I wanted to extend the functionality of the filter query with...more >>

I don't think I ever resolved this issue & now I am quite concerned = about my growing MSRepl_Commands table. It has over 9 million rows. What steps can I take to reduce the number of rows in this table? Thanx! --=20 JUDE...more >>

Good Morning, I have a dude with a new SQL implementation. The scenario is a Central office with an SQL server and 10 branch offices with sql server too. I need to replicate branches data Base with the central sql. All the branches could see the same DB. It is possible to implement with...more >>

Hi all, Our setup is pretty simple, one transactional box, a remote distributor, and a reporting server using one way transactional replication, push subscription, no immediate updating. (All boxes SQL 2005) Around 3am the sql server agent died on the distribution sever with this message in t...more >>

Hi, I tried to implement Snapshot replication and collected all the test results. Finally dropped all the replication stuff from server,but the host DB is still showing as "Shared" and i need help to remove this.Not sure how to proceed. Any help will be great. Thanks, Shyam...more >>

replication is failing with mssg "Error at parameter 34 during datastream processing of parameterized command." any input what could be the reason for this failure and what action should i take to sort out this issue ? From http://www.developmentnow.com/g/114_2003_7_22_0_0/sql-server-replication.h...more >>

Hi How do you clear out the distributor? I am able to clear down the log using sp_repldone, sp_replflush if there are large errors. However, how do I clear out the distributor assuming that it's trying to execute a sproc that might not have been replicated? Thank you Simon ...more >>

Hi, My questions is during replication from sql to sql it will create stored prodecudres but from sql to oracle iinstead of stored procedure it will only create sql stmt so during this time it is not using autoparameterisation for simple delete stmt(adhoc stmt),is there a way that we can use...more >>

I have just created a publisher, distributor and subscriber on 2005 using transactional replication. The creation process went fairly smooth but when I right click on the local subscription and select View Subscription Status it shows: "The job failed. The Job was invoked by User sa. The l...more >>

Hi, I need help/guidance setting up replication across dbs. db1 has the same tables as db2. tables have the same fields. db1 has "dbo.table" schema, db2 has "other.table" schema. I setup simple replication and db1.dbo.tables are being added to db2 as db2.dbo.tables instead of just ref...more >>

Hello all and thank you in advance: Question 1) Can I use merge replication with tables that IMAGE data type columns? Question 2) I need to add my uniqueidenity, if I add to the bottom of the column list can be sure that ALTER statement will be transparant and not lock the entire table? ...more >>

Hi everybody, I have a system of 2 PC, with installed Win XP and SQL 2000. I configured one PC as Publisher and Distrbutor, and the other as a Subscriber with a "push" subscription. The snapshot and the merge agents are running on the Publisher/Distributor. This PC is always ON for 24 hours e...more >>

Hello, I have restored a Database to Computer B from a Backup of Computer A. The backuped database was replicated with lots of Articles and subscribers. The restored Database is full of replication stuff system tables. Tables like: conflict_RTM_REPL_MERGE_Aktion_TS_S_AktionAktivitaet...more >>

Hi, I heard that simple delete stmt which deletes no of rows everytime in replication is not using came plan caching why you have any idea or is there any option that we can turn on to use cache plan.. Thanks in advance -- Message posted via SQLMonster.com http://www.sqlmonster.com/...more >>

I need to add multiple new fields to a replicated table. There are sveeral subscriptions to the publication that contains this article. Can sp_repladdcolumn be used to add more than one field at a time? Everytime I add a field using Enterprise Mgr, it takes a while to update all of the subsc...more >>

Most of my tables is dropped after they are created. I cannot tell when this happen. This include stored procedures as well. I checked the maintenance job and none are dropping tables or stored procedures. The funny part is my tables and stored procedure which is published out as articles r...more >>

Hi all, I have one out 20 merge replicaion that just hangs and never ends at step 2 which is the run agent step. I added -Output "E:\ReplStepLogs\repl.txt" -OutputVerboseLevel 2 to my run agent step of the job. In the file I get the below error over and over. I am not sure what query ti...more >>

Hi, Using sql server 2005, we've got transactional replication going between two servers. if i need to remove a couple of tables from the replication, do i have to reinitialize the snapshot every time i do that? or is there an easier way to achieve this? thanks for any help on this, ...more >>

In SQL 2000, you could just click on the orphaned agent for the anonymous subscription in the replication monitor and poof it, but I see no analagous way to do this in SQL 2005. Am I missing something? Thanks. ...more >>

There are "orphaned" subscriptions on my server (Replication folder, Subscriptions), how do I get rid of them? There are no publisher or publications, referencing these subscriptions. Thank you in advance. Leon...more >>

A database has been deleted that had publications set up and these are now causing errors in the 'Replication Monitor'. Under Replication Monitor - Publishers - SeverName - dbname we have a failed snapshot agent that says [SQL-DMO]The name 'dbname' was not found in the Databases collection. ...more >>

Hi, I would like to backup a secondary log shippping database (in restoring or standby mode). I need to use the backup as an up to date test database on the same server but don't have the bandwidth to copy the primary backups over. I've tried the backup command which results in an error sayi...more >>

Hi, i am planning to set up transactional replication for a database that sees upto 10 million transations a day. The replication is meant for disaster recovery and reporting purposes. Are there any caveats that I need to be aware of? I have been going thru the whitepapers published by Mi...more >>

I've been tasked with improving our company's merge replication performance. We are using SQL merge replication and lately we are seeing a decrease in the performance. Specifically, we are seeing more errors, retries, latency, and even missing data. I hope someone can provide insight or s...more >>