We have a merge replication setup in SQL 2000 that synchs with 2 laptops. I need to add a new table to the database that will be included in the new subscription as well as a change (adding a column) to a table already in the publication. What are the steps I need to take to get the schema c...more >>

Hello, How to move 50GB of Publication Database to new Hardware( New SQL Server) quickly without loosing replication inforamtion. Replication Type : Merge OS : Windows 2003 Server SQL Version : SQL Server 2000 Edition : Standard Service Pack : SP4 Best Regards Ponnu...more >>

Hi, I'm running a syncornized mirroring setup using a witness on our LAN. Since we don't use a domain controller, we use certificates for outbound and inbound mirroring connections. We're using sql server 2005 SP1 standard edititon on all machines. The principal and mirror have only th...more >>

Hello everyone, I have two questions: 1. about sp_adddistributor - in the case when a remote distributor is being used does it have to be run both at the publisher and at the distributor? 2. about sp_addsubscriber - where does it fit in the chain of replication setup SPs? I have this se...more >>

Hi, I created 2 windows user named PublishUser and ReplSnapAgent with less previllege. Ran SSMS using PublishUser and created snapshot publication. Used RepSnapAgent user as Snapshot Agent. I got an error saying SQL Server could not create publication 'Product'. (New Publication Wizard) ...more >>

I currently have a VB6 app that I am rewriting. I am now using Visual Studio 2005 and the new app will be a windows forms smart client. I am using SQL Server 2005 Compact Edition as the local database. I have SQL Server 2005 Enterprise Edition setup as a merge replication publisher. I will h...more >>

SQL2005 Win2003 Server Merge agent is causing a cpu spike on subscriber each time it fires. Calling sys.sp_MSenumgenerations90 This just started. Merge has been running well for about 1 month. Merge agent fires on 1 minute schedule, normal execution time is about 20-40 seconds. Now it is...more >>

How i can stop the replication to run thru the transactional update, insert, delete without recreate the other new store procedure? ...more >>

please help ! i don't know why my store procedure of the transactional replication will be recreate the store procedure everyday. After that i will get the error like below: error : Procedure or function sp_MSupd_transaction_orders has too many arguments specified. any solution for th...more >>

Hello , I have a database in SQL2005 is adatabase of 52 tables and is Merge Replicated. Currently 12 Handhelds use this set ... but in the futere we will go up to 60 handhelds. Depending from the changes, Synchronization (Using GPRS) is taking now on average 1 or 2 minutes or sometimes 4-5...more >>

hi all, my sql server has sp4 installed. i have two databases, D1 and D2. And the transaction replication copys table D1.T1 to D2.T1 at 1:00pm everyday. the problem is: when some applications are continuously using table D2.T1, i mean those processes are in runnable status. And then the r...more >>

I recently rolled out replication on our production server (MS SQL 2000 8.00.2039) and every time a subscriber tries to sync the following always appears in the Merge Agent History: "Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts)" This always takes over 5m...more >>

I recently setup merge replication and for each subscriber I add and try and synchronize I get the following error message: "The Process Could Not Log Conflict Information" When I view the details of the error it states the following: "The Process Could Not Log Conflict Information...more >>

I am experiencing this problem. Deadlock of these two M$ stored procedures : sp_MSget_repl_commands (Executed by the Distribution Agent --pull subscriber ) and sp_MSdistribution_cleanup (Executed by the Distribution Agent Cleanup job) the offending queries are : >From sp_MSdistribution...more >>

Hope you help me..... Two SBS 2000's (trying to get the damn think to replicate). BROAD has fixed IP of 81.174.xxx.xxx and CLIFT has 81.174.xxx.xxx Broad is set as the subscriber, Clift as the distributor Broad can ping, tracert Clift using IP and Name ISA firewall ports open to allow...more >>

Am I doing this right Create Publication with dynamic filters ie. select * from employee where employeelogin = SUSER_NAME() 1. Create Snap Shot 2. Create Dynamic Snap shot with SUSER_NAME() parmater filled in ie SUSERNAME() = mydomain\myuser 3. Pick a new folder for dynamic snap shot ...more >>

error i get from replication when i force them to run the process. mircosoft sql - DMO(ODBC sql state:42000) Error 14258: Cannot perform this operation while sqlserveragent is starting.try again. But i not restart any sqlserveragent And the sql server servies manager show that all running...more >>

Last week I made the following post.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Running Win 2003 & SQL 2005 on both machines. I created a publication on serverA. I subscribed to it on serverB. I received the error.... Command attempted: E:\Program Files\Microsoft SQL Server\M...more >>

Hi! I'm developing a project in which I have several Sql Server Express and Sql Server Mobile 2005 databases and all of them are subscribed to a central Sql Server 2005 database. Now, I'm in trouble with the primary keys because if i insert two registers with the same primary key in two dif...more >>

All, Transactional Pull model: Multiple publishers with the same articles(2000) : Single Subscriber (2005) I try to setup replication from the second publisher when the first publisher's distribution agent is actively pulling data. At this point, the storeprocedures indicating the insert an...more >>

Things I got to work SQL2K, Merge Publication -> SQL Everywhere (I used the interface in SQL2K5 to do this Subscribe, can anyone show me how to do it in C# 2005 code???) SQL2k Merge Publication with Dynamic filters(i.e SUSER_SNAME) -> To Another instance of SQL2k What I would like to kno...more >>

Hi, I want to write a vb.net program (vb.net 2005 & sql server 2000) to control the replication for sql server. How can I get the exist distribution control object to reinit the replication before I start the transactional replication? using the stored procedure or vb object? Thanks. ...more >>

Merge replication, SQL 2000. Does anyone know if there is a problem with syncronizing caused by the physical order of the inserts/updates in related tables? I am getting some conflicts that indicate a failure due to "... Referential integrity rules require a related record in the table '<t...more >>

We have an SQL 2000 merge replication set that consists of 2 publications. One is for tables only and the other is for SQL views and stored procs. I need to create a new table and revise some triggers in other tables. I also have to add a new SQL view that will be a merge object also. Can I...more >>

I'm reposting this because no one responded to my Dec 12 post. There has to be a way of dealing with upload insert failures. Could someone please point me in the right direction? --------- I have one article giving me problems in my topology which involves multiple Sql Server 2005 Express sub...more >>

Hello all, I have a snapshot publication with several anonymous pulls set up to replicate several procedures and functions. I notice that the created snapshot has a file called snapshot.pre that seems to drop all the functions. I'm not sure why this would be necessary because each .sch file s...more >>

Does anyone know if one way merge replication is used, can changes be made to the client data? Would these changes just be overwritten when syncronization is performed, or would the changes interfere with the replication somehow? Thanks. ...more >>

Hello. Has anybody used the TableDiff utility to compare a SQL Server 2000 publisher and a SQL Server 2000 subscriber? If so, did you encounter any issues with it? Thanks! ...more >>

I execute a sp_addscriptexec because I wanted to create a trigger, but it already exists in some of the subscribers. So, I get the following error: "....\Microsoft SQL Server\MSSQL$SQLSERVER2000\ReplData\20061213182034400\script_trigger.sql' could not be propagated to the subscriber." How c...more >>

Hi I'm trying Merge replication with pull subscriber and dynamic filter. I put -hostname like this: -hostname @@servername at step job of Merge agent at subscriber, so when start first snapshot, show this message: The schema script '\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc\ D001AD...more >>

Hi, I've configured mirroring on the database and selected the high safety without automatic failover. It all seems fine. Now the problem is in the mirroring screen I can't select the High performance mode (Asynchronous ). I would like to test this option as well. I know I can't select ...more >>

When I add the option to add extended properties to the publication, create the snapshot and then distribute I get the following error in the distribution agent task:An invalid parameter or option was specified for procedure 'sp_addextendedproperty' Any ideas? ...more >>

Hi Guys! I work in Govern Department Bank. We just have many experiences about Replication, meanly Transactional. All evolution about Client-Server architecture in the past, make some choice:  Many Distribution application at many sites located in many cities linked through Wan (frame rela...more >>

Hi, I have some problems in transactional replication. Case 1: When the subscriber goes offline mode, I add the same records in the both size (distributor & subscriber). After the subscriber onlines again, the error occurs. Case 2: When the subscriber goes offline mode, I delete the ...more >>

Hi, 1. Can we replicate tables with no primary Key. Will Sql server add some type of constraint in tables. 2. Can we replicate Bitmap/Blob data. What kind of replication is suitable for these scenario...more >>

I have two databases that are used for publication and subscription. One table in subscription was droped by accidence and replication was failed. After I re-create that table and Re-syncronize them, I still got failed and error was like that table is not existed. No matter how I did, it was f...more >>

I currently have a list of users in a SQL 2005 database. Users are authenticated based on their email address, and each user has a number of areas they do and don't have access to. A website is used to add users to the database, or to add area permissions for an exisiting user. I would like t...more >>

I am getting this error in the distribution agent that I setup for transactional replication. The last command which failed is like "CALL sp_MSins_CompanyName$Trans_ Sales Entry (" The table name is lengthy and contains spaces too. I believe this is because of the spaces in the stored proce...more >>

I would like to be able to run a snapshot agent from a TSQL script or from a cmd line. I have merge replication setup to several different publications and would like to script all of the snapshot agents to run on cmd rather on a schedule. I am using SQL Server 2000 with SP3. Thank You in ad...more >>

Hi, I had enabled snapshot replication between two databases in the same dataserver. The replication was failing with error 'Could not find stored procedure ''. (Microsoft SQL Server, Error: 2812)'. I thought that I should have configured it wrongly. I'm trying to delete the publication or at...more >>

Hello, I got error message "Prefetch objects failed for Database ‘MyDB’" when I try to run the snapshot agent to create a snapshot. It is a SQL 2005 merger replication. Further more I find it can generate the snapshot if there is only one table in articles. If I add one more table the err...more >>

Here was my problem. I have a database with replication. All I need to do was restore the database from a backup (totally different data from another server). The restore process was messed up because I was not aware there is replication in place. So the database status is always loading. I ha...more >>

We've got transactional replication set up from 2000 to 05. Is there a way to not let the snapshot agent to drop and recreate the destination tables, but rather truncate them? Thank you, Igor *** Sent via Developersdex http://www.developersdex.com ***...more >>

Guys, We have a transactional replication set up with a single publisher and a single subscriber. Recently, replication failed due to the following reason: Data, erroneously, was deleted from subscriber. Then, to make the publisher and subscriber synch, the same data was deleted from pub...more >>

Hi, I have a fairly major problem with my SQL Server 2000 merge replication setup. Certain of my subscribers are causing conflicts such as: "The row was inserted at 'MyServer.MyPublication' but could not be inserted at 'Subscriber.Subscription'. Procedure or function sp_ins_A7E27E390276442...more >>

In my customer's setup we have 1 publisher and 45 subscribers, with 6 publications. One server gets full data using a straight Push subscription. All other servers receive full data for some publications and filtered data for the other publications using HostName as the filter. To achieve this...more >>

I am replicating (transactional and snapshot) a production DB to a reporting DB. I have then a job that runs that processes the data in the reporting DB in order to produce some custom reports. Does replication have a way so that once the replication is done it will start a job on the reportin...more >>

Hi I was thinking of using sp_browsereplcmds to recover some of the lost data. Im not quite sure i understand this correctly and need some help. I ran select transaction_timestamp from MSreplication_subscriptions on the subscriber to get the last transfer date. In between, a row was updated...more >>

Hi all, I have a merge replication with the publisher SQL Server 2005 and the subscribers SQL Mobile clients.On the server side, I need to execute a stored procedure so as to export data when a subscriber synchronization is successfully completed. I want to know if there is a way to handle a ...more >>

Is there a way to know if the replication is successfu? How would I know that the data in the subscriber is same as the publisher?...more >>