I cant seem to understand the use of this parameter. Can someone help me understand this in very basic replication terms ? ...more >>

Currently i have an article that publishes a stored proc. How can i change its properties to publish the execution of the stored proc ? i.e. when the sproc executes on the publisher, instead of propogating all the changes affected by the sproc, i would like to invoke the execution of the same sp...more >>

Contantly there seems to be a blocking issue between the distribution agent, the log agent, and the distribution clean up agent. This will eventually cause one of the agents to shut down (the log agent). What can I do to elevate this situation and why is it happening? --Kristy ...more >>

I have an error in our replication server. The error reads, "The merge process could not perform retention-based meta data cleanup in Database "ourdatabasename". The detail portion of the errors indicates that "The index entry for row ID WAS NOT FOUND IN INDEX ID 2, of table 421576540 in d...more >>

Hi, I have a central server witch fetches information from other local servers. I setup merge replications so that all changes made at local server would be replicated at central server in the night. Now, I want all the information on central server (that is, the combined information from a...more >>

If the logreader stops (separate distributor server from publihser) and cannot connect to the publisher for - let's say - 4 hours, is that data lost or will the transactions to be replication still be in the tlog? and replication will catch up - in total (including the 4 hours down)? ...more >>

Does the snapshot agent have to run if I already have a copy of the database on the subscriber? We are doing a push subscription on transaction replication. I don't remember it running before, but today it is. --Kristy ...more >>

Hi to everyone. We are a small company that cannot afford having a cluster (low budget). Instead, we are looking for alternatives to have two SQLServers, one of them configured as a secondary server, so if the former must the put offline (mantainance, for example) the latter can "hear" user...more >>

Running SQL 2000 SP3 & Win Adv 2000 Came in this morning and one of my Merge subsctiptions has the error..... 'Failed to enumerate changes in the filtered articles.' When I look at the last command, I see.... create table #belong_agent_-1933363311 (tablenick int NOT NULL, rowguid uni...more >>

I have transaction replication set up and I want to set up a report to check whether or not my replicaiton is up and runninr. Can someone suggest the kind of queries I can run in Publisher, Distributor and Subscriber to check if Replication is up and runnin or not. Thanks in advance. ...more >>

I have a mobile app that uses merge replication. I need to provide management and easy to access (and read) report showing when mobile users updated last. As I am using SQLCE, I have to use anon subs, but... each publication has only one PDA reading it. I need to know where to look in th...more >>

How to resolve in this problem in transactional replication Could not drop object because it is referenced by a FOREIGN KEY constraint Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hello Im getting the error below on my Distribution Server. "Error at parameter 1 during datastream processing of parameterized command." I followed the article below and configured the Distribution to log the error on a text file. Article ID 312292 - HOW TO: Enable Replication Agents for ...more >>

Which third-party synchronous replication software are you using? I googled and found Veritas Volume Replication, NSI Doubletake, among others. K.- ...more >>

Is it true that log shipping is only for a readonly secondary server? Thanks, Gus ...more >>

We are load testing one-way trans repl by replaying a profiler trace on the publisher. The subscriber was restored w/ a backup. Distr agent failing w/ foreign key constraint errors. We determined this was due to an update stmt coming across as a delete, then insert. Is this profile...more >>

I am planning a new deployment of SQL Server 2K. The scenario has a SQL Server at our co-host facility to support our ecommerce activites and a SQL Svr at our manufacturing facility to support our order fulfillment activities. The ecommerce datbase is a subset of tables from our manufactuirn...more >>

Using transaction replication on Sql 2000 Server SP3 I have setup server A as the Distributor and Publisher. Server B is the subscriber but keep getting this error message on the snapshot agent for the publication. "The process could not bulk copy out of table '[dbo].[syncobj_0x30373033434...more >>

Hello, I have merge replication with a central publisher/distributor and 6 subscribers with anonymous pull subscriptions (laptops). For this example lets say I have table1 (T1) and table2 (T2) joined with an enforced 1 to many relationship. I have 2 issues: 1) After inserts in T1 and T2 at a...more >>

Hi, Which replication is better for standby and disaster recovery solution? Transactional replication or Merge Replication? Please advice. Sam ...more >>

here is my question: I have a two SQL servers X and Y. X is the prodcution server and Y is a standby of that server at remote location for the disaster recovery purpose. I have merge replication setup between X and Y to keep them in sync. Now if by any chance server X goes down (disaster sit...more >>

If I uncheck the property to allow anon pull subscriptions what effect will it have on my current operations? I have a Publisher and Distributer on one server that replicates with Push to one subscriber over a WAN. It appears through reading lots of posts that the distribution clean up agen...more >>

Hi, I have a transactional push replication setup with the snapshot been run before. I just added a new article by 'sp_addarticle' to the current publication. Is any way I can have the new article schema and data refresh to the subscriber without having to start the snapshot agent again ?...more >>

I have two Win2000 that are in a domain. SQL1(SQL server) acts as the distributor and publisher. SQL2(MSDE2000) acts as the subscriber. Push merge replication is running well. I want to PULL the db from SQL1 to the db on SQL2, failed :The process could not connect to Distributor. Cannot gen...more >>

Is it safe to stop the SQL Server Agent service to reset the agents while a merge agent is running? ...more >>

Hi All: How can I view inserts/modifications/deletes executed by the Merge Agent, when doing Merge Replication? Does Publisher DB has a table which stores all the statements which are executed during syncronization? Please let me know. Thanks, Anukul ...more >>

Hi everybody. Does anyone have an idea of any utility that is available, that synchronise Schema of a replicated Data Base with the schema of a standard data base? ...more >>

Is there any place we an set latency for transactional replication...more >>

I have setup both a push and pull sql replication environment but if I make a change at the subscriber, the publishing database does not overwrite the subscriber database. If changes happen at the subscriber I always want the publisher to overwrite the changes made since the publisher is th...more >>

Hi Experts, How do I know when data was last replicated (per database)? How can I query the status or erorrs if the replication failed. I need to get it and display it from my application. Thanks a million, Avi ...more >>

Hey all...here s my problem, let s see if u can help me please ! : I have a DB with some tables published in X server, i made a backup of that database, and restore that backup on another server ( Y ) , but it s still beeing locked for the replication service, but the Y server doesnt have that ...more >>

I have a log shipping from production server to stand-by server. Everything is ok except the transaction log growth continuously. Every time I truncate the transaction log, the lof shipping would be stopped and I need to run the log shipping wizard again. How do I trancate the transaction...more >>

I'm a little confused...... If a subscription is setup for anonymous pull subscriptions does the subscriber need to have any access privileges on the domain where the publisher resides? For anonymous pull merge subscriptions the only file access is done on the publisher end using the publ...more >>

Test environment - Transactional Repl - Remote Distr - 1 Subscr. 356 table publication, pub db size: 50Gb. Many tables with timestamp datatype, those columns removed from published article. At publisher added NOT FOR REPLICATION for each table(column) w/ IDENTITY property. Backed up pub...more >>

I have setup the transactional replication with one table which is working fine. I need more tables to publishing database in order to test it. How to do this? Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded...more >>

I added the NOT FOR REPLICATION option to my update trigger at the pub & subsr, I update a row and the thing is still firing. I am certain because my distr agent fails with an err message pointing to sql syntax only found in the trigger. Here is start of trigger syntax at SUBSCRIBER: ...more >>

http://support.microsoft.com/default.aspx?kbid=893437 -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com ...more >>

If you require further information, I will be able to provide....more >>

I am replicating all tables and views in a database with snapshot replication. It is giving an error because View2 is dependent on View1 but it is trying to create View2 first. I was going to delete and recreate View2 so it would come after View1 but when I went to delete View2 I got an error ...more >>

I have two publications set up on my db, one for ordinary users that employs horizontal/vertical filters, the other for admins with no filters. I noticed over a period of time records going missing and when I checked my conflict tables I received the following: "The same column(s) of the same ...more >>

SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers: [Subscriber Server Name]: Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(error not found). The subscription coul...more >>

Hi All, Firstly an apology in advance if this question gets asked 15 times a week - I'm not normally involved in SQL Server development and a quick scan of the newsgroup didn't show anything.... Here's the scenario. We will have an application running in a central office that uses SQL Se...more >>

Hi all, I have met the error 2147200925 Message: create table #belong_agent_-2085858875 (tablenick int NOT NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage varbinary(255) NULL, colv varbinary(2048) NULL) ------------------------------------- Line 1: Invalid syntax near ...more >>

Hi everybody, I am looking to establish a merge replication, whereby the row is identified by a unique key, than might be a combination of multile coloumns Example If the inique id of a row is column1,column2 Whenever this row is changed in any of teh sites, the replication should updates r...more >>

Hello everybody from the sunny Madrid (Spain). I have this problem: I am working with SQL Server 2000, 2 nodes cluster, Transactional Replication. For 2 years we have been working correctly but a few days ago I can not run the Distribution Agent for the distribution of a new Snapshot. We have...more >>

I would like to avoid enterprise manager when it comes to using the "Configure Publishing and Distribution wizard for 'Server'" wizard. It seems to me that there are no stored procedures or sql-dmo objects that allow me to automatically set up the publisher and distribution database. A refere...more >>

If a MS represenative monitors this group, I am curious if there is a known bug where the merge agent quadruples the value stored in the downloadreadchangesperbatch? Evidence of this is seen by capturing calls to the procedure shown below where the first paramter is the number of rows to ...more >>

How to resolve this problem The process could not create file 'C:\Program Files\Microsoft SQL Server\MSSQL\ReplDat\unc'. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I have my replication "working", though I would like to script as much of the client installation as possible, and running into mega headaches. Here's the setup: Client - MSDE connects to Publisher/Distributor via VPN annonymous pull subscription I can install my MSDE, c...more >>

I have transactional replication running in sql2000. I need to find out whether there are pending transactions to be replicated and I need to do this query. Is there any way?...more >>

Correct me if im wrong but do i need to create many publications for SQL should i have stored procs,views,indexed views,etc in addition to the tables ? It seems that when i have just one publication with all these objects published in it and when the distribution agent runs, it sometimes tends...more >>

Hi All: I have setup a Merge Replication over VPN. It has setup the Snapshot Agent Schedule to run Once every 1 week. & I have set the Merge Agent to run continuously. Can I change the snapshot agent schedule to run on Demand? Can this is configured once the replication is set? Given that m...more >>

I have a 100gb db on win 2k sp3/sql server 2k sp3. I am trying to start trans replication on a newly restored backup that is across the wan with a push subscriber. here is the problem. When it is trying to connect I receive a "Timeout expired (Source: ODBC SQL Server Driver (ODBC); Error numb...more >>

Hello, I have 30 remote WinXP sites connected to a Win 2K3 server via VPN. Each remote site runs MSDE. Basically, they are automated data aquisition machines recording into a DB about 200K of data every 15 minutes. The data at each remote site needs to be replicated into its own DB on th...more >>

I'd like to be able to either change the default profile settings or change the default profile to a user defined profile. So far I've only been able to change the profile after the merge agent is created. I'd like to change the defaults for any new merge agents that are created. TIA ...more >>

Is Updatable Subscription available in 7.0 version? Thanks! ...more >>

I need the move the transaction log of a publication database to a different drive. I tried to detach the database to move it but a replicated database can not be detached. I would not like to remove the publication and replication settings and reinitilize 300 subscribers to make this happen...more >>

I have setup a transactional replication which only requires to replicate inserts only. SO FAR SO GOOD. Every night we need to truncate all tables and re-start replication. Since deletes and update commands are set to NONE so we are not worried about it since these changes will not be carr...more >>

Hello, For my DR soluion I am using an XP1024(Hitachi) array to sync data from production site to DR site. My SQL servers take up a lot of bandwidth during high business times with other applications. What is another way I can sync the data from site A to site B? Is replication the answe...more >>

Hi, i want to enumerate all publishers from a sql server instance. Sometimes it works and i get the publishers, sometimes not, i get an empty queryresults-list with just the column - names. I tried publisher and publisher2 object: Syntax object.EnumPublications( Database , ReplicationType ,...more >>

Hi we are using transactional replication with the updating from subscriber option. So we have triggers on both databases the publisher and subscriber for referential data Integrety. Now Occasionally we have to do a new snap shot and we get errors saying cannot drop table as it is referenced ...more >>