Hi I want to add an article to an existing publication using merge replication, the database is around 5 Gb. Using sp_addmergearticle defaults to invalidate the snapshot and a new one has to be created. When the new snapshot is applied to the subscriber is there anyway of just applying just...more >>

Is there a way to change a subscription from a Pull subscription to a Push subscription without dropping it and creating a new one? This is in SQL Server 2000 using transactional replication. Thanks ...more >>

I need to increase the a column in a replicated merge database. The column is 100 char in lenght and I need to change it to 200. I have read the "Schema Changes on Publication Databases". But it seems to be a little confusing. Thanks....more >>

SQL & Win 2K I have a dB that I restored and it got hung up at a phase where it is '(Loading)'. I ran the script below, from a post of Paul's from a while back, and an error message was returned that 'Database 'xxx' cannot be opened. It is in the middle of a restore.;' How can I get rid...more >>

Hi all, I have a question about the replication that induce any blocking or deadlock in SQL? the scenario is server A will have merge replication with server B on database D1 with table T1, concurrently with a transactional replication with server B on database D2 with T2 (push subscription)....more >>

In transactional replication, If I have the publisher and subscriber with tables of the same schema, i.e. pubServer.marketing.dbo.customer (customerID, int IDENTITY(1,1)) subServer.marketing.dbo.customer(customerID int IDENTITY(1,1)) which table do I set the NOT FOR REPLICATION on. The Publ...more >>

I have setup a merge replication between SQL CE and SQL 2k and I would like to delete the data from SQL CE after the synchronization. Is there a way not to include delete transactions in the merge replication? Thanks, ...more >>

Hello I am trying to push a subscription but get this error message Subscriptions were created successfully at the following Subscribers: TERM2 SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'TERM2'. 5 - (Access is denied) Any help with this woul...more >>

Win & SQL 2K What is distrib.exe?? I have it running 15 times in my task manager. It this a prog that distributes(pushes) transactions to subscribers?? Is this an SQL thing or should I go look else where. Also logread.exe is running 3 times. Is this anothere SQL thing? Larry......more >>

hi all, I am using merge replication with push subscription.i am getting conflicts in some tables.i am not resolving any conflicts.so the system can resolve or those conflicts can be cleaned.please suggest how to resolve conflicts. with the help of rowguid can i retrive the entire record whi...more >>

Hi, I've got a push merge replication set up between two sql servers on the same domain. I have a table with about 1200 records in it. For some reason when I publish the article and set the identity range values it chooses a Next Range Starting Value of over 7000000 when there are only the 120...more >>

Hello All, I'm using Transactional Replication and it's Push subscription. I want to Reintialize 1 article, i did this, exec sp_reinitsubscription @publication = 'inventory', @article = 'customer', @for_schema_change = 1, @subscriber = 'subscriber' but error "Cannot reinitialize artic...more >>

Hello All, I'm using Transactional Replication and it's Push subscription. Can you plz give me the complete steps to add a single table w/o starting snapshot for all tables. And another question, BOL says sp_refreshsubscription for Pull and sp_reinitsubscription is for Push Subscription...more >>

I am new to SQL replication and I have an issue with the identity column not properly synchronizing between two MSDE databases. I have turned on the (not for replication) switch and changed the identity seed and identity increment to be different on the subscriber, but as soon as I pull the sub...more >>

I have enable a transacional replication of only one table in SQL 2000. However the replication continue with status of ok, occurring to each 1 minute , it seems that stop to function, is necessary always to reinicializar the subscript, every week. Somebody could help me?...more >>

I am trying to set up merge replication between a publisher and 1 subscriber. I have selected the "include declared referential intetegrity" option. I have added "Not for Replication" to all of my triggers. Occasionally, I end up with replication conflicts (either at the subscriber or t...more >>

When setting up replication of Stored Procedures & Views I made a = mistake, I did not change the properties to tell replication to = replicate the execution of the stored procedures. How can I change this? Originally, I just selected publish all & now when I look at Articles on = the publi...more >>

Hi There, I'm using the replication ActiveX controls in a VB application. I'm able to connect to the publisher which is also the distributor using the server IP address as such: server.Connect(server_ip, username,userpassword) I'm also able to ping the server using the server IP. Bu...more >>

I'm trying to create a simple publication for a single table. The table has nchar and nvarchar columns with a primary key created on the first nchar column (4 characters). I receive the following error: Error 515: Cannot insert the value NULL into column 'step_name', table 'msdb.dbo.s...more >>

Hello all, I'm planning to setup replication between our local development database and our remote production database that are connected with a T1 line. I want to publish a subset of the tables only and I want to replicate the data manually after it has been checked by someone. Now the ...more >>

Hi, I have a snapshot publication that a subscriber re-publishes (i.e the same articles are used in a publication setup on the subscriber). The problem is that the subscriber is not replicating because the snapshot tries to delete the table article and recreate it (since the artice is p...more >>

I need a script that will create an transactional article for each table in my database that can be replicated and also create the pull subsciption on the target database? I have tried creating one article with Enterprise Manager and then scripting it out and just changing the table names, sa...more >>

Hi, Is it possible to use MSDE Replication (with Access 2002) without SQL Server licensing ? In this link, at "Administrative Tools": http://msdn.microsoft.com/library/en-us/dnapg/html/apg03.asp?frame=true#apg03_admin it seems that these administrative tasks are available. However, I ca...more >>

Hi, I have some indexed views as part of my article. From my application i alter the view as i can add columns dynamically in the underlying tables. The replciation of the columns is not a issue but i cannot replicate the altered view. I am using merge replciation between SQL Servers and MS...more >>

i got this when "{call sp_mergemetadataretentioncleanup(?, ?, ?)}" runs...ANY help is greatly appreciated!!!!!!!!!!!!!!...more >>

Hi, Can anyone tell me the best way to configure sql server to allow publication of data from a pre to a production environment. I'm thinking along the lines of a typical content mgmt app where users can work in pre and publish to prod when ready, how would this normally be configured? T...more >>

We are running SQL Server 2000 SP3. I have setup transational replication and it ran ok. After I used force protocol encryption, the snapshot agent fail with an error : Cant bulk copy out table dbo.syncobj_ followed by a guid. Does anybody had the same problem and how can it be fixed? ...more >>

when reinitializing a subscription, I sometimes get the error: "cannot drop table xxx because of a foreign key constraint" I need the schema to be reinitialized so it HAS TO drop the table rather than truncate it and re-populate it, It should ignore constraints when the replication pro...more >>

Hi There, I was wondering if there is a way of determining programatically if the merge agent is running? If it is running is there a way of stopping it and restarting it? Thanks Vivek ...more >>

I am getting the following error message when I try to do a transactional replication of a large table with a text column: Error Message: The process could not bulk copy into table '"monitorResults"'. Error Details: Expected the text length in data stream for bulk copy of text, ntext, or i...more >>

Hello All, I'm using Transactional Replication. I have compress snapshot file now I want to configure it on Subscriber. I saw BOL and it says, 1. In Microsoft SQL Server Enterprise Manager, expand the subscription database and the Subscriptions directory, right- click a subscription, ...more >>

Greetings-- We are running queued updatable transactional replication between one SQL Server 2000 and one MSDE instance (SP3 on both). Replication died last night with the following error -- Distribution Agent Line 1: Incorrect syntax near ',null,' Last command: EXEC sp_MSins_<table...more >>

sql2k, sp3a snapshot created without error, when distribution agent runs for the transactional replication: Insert Error: Column name or number of supplied values does not match table definition. Why is this happenning ? ...more >>

Hi, We have a database replicating from the DMZ to an internal server. On the internal server we have a role which uses NT accounts. On the DMZ this is not needed since the role is used for internal report viewing. Problem is when database is replicated(snapshot rep.), access to the role is re...more >>

I'm using Transactional Replication. How can I add a new table on subscription database w/o restarting snapshot. I successfully Add Article using sp_addarticle and also add subscription using sp_addsubscription. but I didnt find that new table on subscription database. then I try to start sna...more >>

Here's a scenario that I'm trying to figure out. SQL Server 2000 based. I've got 2 databases - a production database, and a reporting database. In this environment, I want to be able to replicate new data from the production database to the reporting database on a regular basis. Howeve...more >>

Hello all, I am looking for a "beginners guide" on setting up the automatic (daily) replication of a production database to an identical database on another server. This second database is to be used for training purposes. This is for MSSQL 2000. I have a customer that wishes to do this,...more >>

It was suggested that I 'drop the packet size' to help my intermittent merge replication issues (failures.. General Network Errors). How/where would I do that? any info is appreciated. Thanks. ...more >>

Hello. I keep getting this error on both of my distribution servers in regards to the log reader. "General network error. Check your network documentation." I have read the archive for this group in regards to switching around some of the log reader settings.. I have tried the follo...more >>

Good Morning! Running the Index Tuning Wizard against a database that is the Publisher in a Transactional Replication, returns, “An error occurred trying to execute a SQL statement,” when analyzing the database and the workload. Running the same statement against a Subscriber or a data...more >>

Hi, I have a trasactional replication setup in SQL 2000 with SP3. Accidentally, I deleted a row in the suscriber table. When I deleted the same row in the publisher database, I have error in the replication monitor "the row was not found at the Subcriber when applying the replicated command"....more >>

Hi we are using merge replication with identity range management, default by server between sql 2000 and MSDE 2000. I have a small question regarding identity range manegment, if any one have information please let me know. I have set up identity range for "Jobs" table as publisher 100, su...more >>

Running Win2k & SQL 2K This AM when I checked my SQL servers, I had a red 'X' on the snapshot folder of my central server. When I expanded it, there were no snapshot agents. I have 45 or so publications on this server and know each one has a snapshot agent. HELP!!!! How do I get t...more >>

In Set subscription priority box, for a merge replication, it is stated that when assigning priority to a subscriber, changes made by a hiher priority subscriber is not overwritten by a change by a lower priority subscriber. Is this the case all the times or only in conflicts moments. I expla...more >>

I am running SBS 2000. I use SQL (in SBS) as the transactional database for Great Plains and Sales Logix. I want to set up an OLAP environment for data mining, but I want to put the OLAP stuff on another server. My plan is 1) buy a new server, 2) buy/install Win2003 Server and SQL Server 20...more >>

I have a silly problem that could have been solved months ago if it was caught, but it wasn't. I purchased a Dell Poweredge as my server to host publication databases that a string of retail stores synchronize (pull merge subscriptions) with to share customer information. The developer of ...more >>

Synchronizing passes information (sometimes sensitive) over a wire. My client, the U.S. Government, will be sync'n over a VPN tunnel to the main SQL Server database from various field office locations across the country. My question is: can the sync operation (bulk load/transactions passed) be ...more >>

Hello, We have a MSDE subscription that resides on a mobile computer. We currently have the pull subscription jobs scheduled to run from 1am till 5pm. This synchronizes the data well. However we are wondering if there is a way to manipulate the jobs scheduled time to start whenever we chos...more >>

Hi, I am using merge replication with anonymous pull subscriber. My problem is getting a way to consistenly replicate database objects (SPs/Views/UDFs). Replication kind of support it, but then you are not able to modify (drop/alter) the objects and it doesn't work anyways because it depends...more >>

Hi Guys, Need you help on this one. I have a eplicated database that is rather large (1GB+), and I am getting more and more requests to alter articles in the existing publication. As there is lots of data I am having to carry out the following: 1.) drop the article 2.) drop the subscr...more >>

I'm working with a client on a problem where they setup transactional replication publications, push out a subscription, the snap shots are created, the data is initially pushed out to the subscriber but no Logreader agent is created - So no transactional replication occurs. The Sql server, ag...more >>

During the snapshot generation, I get this eror while the snapshot agent is generating the schema script. Here's my setup (all win2k sql2k servers 3 diffrent machines) all pull snapshot/transactional replications. On my sole publisher on its own server, I have 4 publications, two per publi...more >>

We have set up a Replication (Merge continuously) with the Publisher and the Subscriber on 2 different machines - different Servers SQL 2000. We intended that if the Publisher machine broke, we can continue our data operation on the Subscriber machine - just like a "fail-over". That's ...more >>

I have a snapshot/transactional replication publication with the following row filter: SELECT <published_columns> FROM <<TABLE>> WHERE ItemName not in ('dbsvrip','otfrconn','mapdir') and AppTypeID<>7 The snapshot generated just fine, but now none of the changes to the table are getting rep...more >>

Hi, We have recently upgraded from SQL7 to SQL2000 SP3 Enterprise. Our transactional replication log agent has failed with the description "The step did not generate any output". Caught the message within two minutes and manually restarted Log Agent and it started succesfully and it appea...more >>

Hello. I set up transactional replication with immediate updating subscribers. The Publisher and distributor are on one server. I create a publication on one table. The defaults for the table article properties are both Insert and Update are checked but no delete option. I want to make chan...more >>

I am replicationing 3 tables using Tranasctional Replication. The data on the the other server is only used for reading. I continue to get errors daily "unabale to execute sp_repldone" I also get "Waiting for backend conections". I have tried changing the querytime, batchsize. I recently have...more >>

Hello, We are running SQL Server 2000 SP3. I have setup static merge replication with join filters. When we initialised Merge Replication everything went ok. We made publications, Run the Snapshots and pull them to the subscribers. Now I made a new Publication. When I run the snapshot agen...more >>

Hi, I have a problem in merge replication which is related to the snapshot propagation. I have created a publisher in windows 2003 machine, sql server 2000 with sp3 and subscribers in msde sp1. When I am synchronizing the subscriber with publisher I got the following error: “The schema s...more >>

Hi, i am working on the development of a data warehouse tool as a windows application in VB.NET, that will be storing atmost 3 PRODUCTION databases. The senerio is as follows : 1. My source database don't have a change log Mechanism i.e if any change is made to the production da...more >>