I have some stored procs in a publication , but a "select name from sysarticles" lists only the tables.. Why is that ? ...more >>

How to use join filters with transactional replication ? Thanks ...more >>

Geeeeeeeeeez ... Trying to resolve this goofy foreign key error on a merge replicated database in SQLCE. So I ripped out the database on SQL2k and started over. Dropped replication from the server, created a db with all empty tables. Repopulated the basic "prospect" and lookup tables wit...more >>

Hello, Is there any way to reset the "Next range starting value" on a table with Identity Range management? For some reason, the next range starting value has gone too high. The maximum identity is 32767, and the next range starting value is 32650. I did have the range size at subscriber...more >>

i have setup replication on server mssql v7.0, but the replication monitor does not display. have also tried via tools -> replication -> show replication monitor.But after selecting the server with the distribution database, it does not expand any further to show the agents. has anyone seen ...more >>

Hi, I'm getting the error below when executing: sp_addsubscription. Prior to this I have, added the pub with sp_addpublication followed by sp_addpublication_snapshot followed by sp_grant_publication_access followed by sp_addarticle. SQLServer 2000 SP3 contains the Publication and the Dis...more >>

Shouldn't he publisher and the distribution db have the same tables marked for replication in both. On the publisher I run the following query to find out what is being replicated. use dce01 select * from sysobjects where replinfo <>0 the results are as follows: Areas Category Categ...more >>

I have a Production SQL 2000 server that is SQL 2000 SP2. We have another server that is a DEV server that is running SQL 2000 SP3a. I need to set up either transactional replication between the Production server (SP2) and the DEV server (SP3a). Does anyone know if this presents a problem,...more >>

When does the script specified in the @schema_change_script parameter for the sp_repladdcolumn and sp_repldropcolumn get fired ? Is it after the adding and dropping of the column on all ends or before ? Thanks ...more >>

does anyone know about the sync issues and how to resolve them when you restore the replicated databases on a different(new)server and create replication from running the script generated from the old replication enviornment?...more >>

Hi, during the initialization of the subscriber from a mergepublication the COLLATE definitions were not defined in the created tables of the subscribers. In the snapshot directory I searched the right schema script and I saw that the collate definition in the create table command was not de...more >>

SQLCE database being replicated. I have 3 tables where I'm getting an exception on Inserts and I've isolated the issue to the foreign key (I can do an Insert on those tables if I leave the FK null). I have no constraints on any of these tables (except the PK), and I've dropped all relations...more >>

hi all; when i first read about merge replication , i used to think that: when synchronized,subscriber receives changes at publisher and publisher receives changes at subscriber and therefore both would always have same data. but when i configure a merge replication with pull subscription (...more >>

I am seeing the following conflict message in a merge replication system. Statler is the subscriber (also, remote distributor) and EMGSQL1 is the publisher The row was updated at Statler.Caryn but could not be updated at emgsql1.caryn. Can not update Tlightbox because TlightboxFile exists....more >>

Hi! I'm new to SQL Server and replication but I need to setup a publisher with 10 subscribers using Transactional Replication. My initial problem: the initial snapshot is trying to drop my tables in the subscriber database and I don't want this to happen! (even because it fails! The schema...more >>

I know how I can set-up my distribution agent jobs to log them to a file and up the verbosity of the procedure. I am in the process of creating snap-shot's of my stored procedures for replication. The Snapshot agent works just fine, it is when I use the distribution agent to send it to the ...more >>

Is it possible to run a query against a table and show records that have been successfully replicated to the subscriber? Thanks in advance Tim ...more >>

Hi, Which type(s) of publications keep the relationships and constraints when the schema and data is pushed over to the subscriber ? ...more >>

Hi I'm Using Merge Replication to replicate info from a Pocket PC app. This info must be integrated with legacy systems in FOXPRO. Is there a way to obtain changes (new rows and updated rows) in tables to pass it by textfile to these legacy systems? For now, i'm experimenting with a status...more >>

Hi, I need to transfer a database from MSDE to SQL Server. I can use T-SQL to detach a database, copy the .mdf and .ldf files to another server and re-attach them there, but I do not want to use the Import and Export Data (via Enterprise Manager) if possible. I need this to be as easy as poss...more >>

I have setup merge replication and it appears to be working fine multiple publishers to a single subscriber. with continuous push subscription If the subscribing SQL Server is unavailable for a period of time the replication monitor shows an error "could not connect to SERVERNAME" Ok so ...more >>

Hi, Is it possible to make regular back ups of a database in such fashion that it is a bit like a version control system.. where you store differences (incremental?) but in such way that backups are made daily or weekly and you can decide to restore a backup from 20 days ago? In other wo...more >>

Scenario: SQL2K SP3. - A "simple" transactional publication with three articles, subscribed to by numerous anonymous subscribers, including a local database on the same server. After successfully applying a freshly-generated snapshot at any subscriber, the Distribution agent (at any subscri...more >>

Hi there, I have two servers setup at two different locations, one a publisher(server A) the other subscriber(server B). I'm using Merge replication and SQL server 2000. We have teams working in remote areas gathering data in laptops that have been setup as subscribers to server A. How can...more >>

sp_repldropcolumn @source_object = 'abc' , @column = 'col1' fails with the message Server: Msg 5074, Level 16, State 1, Line 1 The object 'DF__abc__abad__2BFE89A6' is dependent on column 'col1'. Server: Msg 4922, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN col1 failed because...more >>

Hi, We have setup one way transactional replication on SQL 2000 SP3a. It was running fine for weeks and now the distribution agent fails with "Invalid Column Name 'Name.' " message. I tried re-starting the agent, even reintializing, but it doesn't work. I set the verboselevel to 3, and ca...more >>

Hello, I have 10 machines: 1 - publisher (on machine A) 1 - remote distributore (on machine B) 9 - pull subscribers (on machines C1 through C9) I got a new machine D. I would like to move the distributor from machine B to machine D without re-creating all the subscriptions from scratc...more >>

We have set up a publisher (SQL 2000 SP3 on W2003). Next a SQL CE subscriber subscribes to a publication. This works using the IIS. Everything works fine in a test environment. Now we are putting this into production. When the subscriber is synchronizing the first time, everything goes fine. ...more >>

Hi I'm setting up transactional replication between a windows XP machine(DEVFRANCIS), and a windows 2000 server machine(ECTESTING). I've setup the publisher and distributer on the XP machine, and wish to execute the push new subscriptions wizard from the XP machine to the windows 2000 mach...more >>

I have a snapshot agent that I cannot get rid of. The publication did not exist, so I went into distribution.MSsnapshot_agents table and delete it. When I refresh the snapshot agents folder, it is gone. At some point, the damn thing gets recreated. I am not using dynamic snapshots. It is a...more >>

Sorry , Im very new to Sqlserver replication Thanks in advance (First Doubt) What are the limitations of the Merge replication??? - 6000 bytes for row length ( excluding the size of TEXT , NTEXT and IMAGE datatype that are fully supported) - Conversión from datatype "timestamp" to "b...more >>

Hello, I need to continuously monitor the status of a SQL Server 2000 Merge Replication agent; I was originally hoping to use the SQL Merge ActiveX control, but that appears to only give me a status when I'm starting and stopping merge replication from the same VB program. What I need to d...more >>

Ok, I think I have a working solution. I've worked the past few days finding a lot of issues (not replication related) which caused my headaches with replication, ie the @@servername was null, and when creating a stored procedure snapshot it would complain about unqualified inserts. Learned a ...more >>

.... for all the time they take to help all of us working on replication issues. Keep up the good work gentlemen and Hilary and Paul, make sure you guys have your books out there on Replication in SQL 2005 as soon as it hits the market.. Get it out around the same time Kalen gets her "Inside SQL ...more >>

I have 2 laptop users that can no longer download merge changes. The error message is in the subject line of this post. The upload part of their synch works fine. Both were successfully merging up/down at some point in the near past. They are using anonymous pull subscriptions from a SQL...more >>

TITLE: Microsoft.SqlServer.ConnectionInfo ---------------------------------------- SQL Server could not configure 'RemoteHost\REPL_DIST' as a Distributor. ---------------------------------------- ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batc...more >>

What is the best way to determine if transactional replication is alive and well? I would like to know if the snapshots are completed, the articles are being published, and that replicated transactions are being processed by the subscriber. -- Bob b...more >>

I am using transactional replication configured as follows 1. Remote distributor 2. No filtering done 3. Nine publications 4. 114 subscribers 5. Distribution agents are set to run continuously The data being replicated is very low column only a few hundred records a day. I am starting to...more >>

Okay, I have been trying to solve our replication problem and have gotten a variety of answers. Here is what we need: A bidirectional , realtime database replication to one or more sites. One server needs to run reports that require database writes and updates. The other runs the user side ...more >>

I've had a post on here before about this issue, but the issue is still present. Here's the deal: I have a publication that consists completely of stored procedures. When applying the initial snapshot, errors are encountered and the distribution process would stop. I have created a new d...more >>

....had posted this in the wrong NG yesterday... Is it possible for an SQL 2000 standard edition server to be the publisher, to an SQL 2000 workgroup edition server subscriber? Is it possible to get a copy of SQL workgroup edition to try it out if we need to? Thanks ...more >>

I implemented Quedued Updating for my transactional replication scheme with auto range management (I used the default values, thinking Mr. Gates knows best;). I did this so that I can maintain my identity attributes on the subscriber. I dropped all the user tables on the subscriber and did...more >>

Hi, I’ve been reading http://support.microsoft.com/?kbid=886839 article in order to re-sync data from remote distributor DB2 (or subscriber DB3) back to publisher DB1 database, after publisher fail. In article example it seems that publisher and distributor are on the same server, is i...more >>

Hello, i plan to setup merge replication between 2x msde instance (for testing purpose on the same pc too). At the moment i didnt have any sql , like dev,sd,ee, so i only can use Access and sp to setup. Here what i did as yet: 1. Setup a DB on the distributor/publisher msde instance and fil...more >>

I just backup an ArcSDE geography database in SQL Server 2000, whose size is about 3.5GB. The backup process was finished and checked properly, but when it has been recovered, some errors occur: First, when you click the data table in the enterprise manager window, choose the design item in th...more >>

Hi all i have a merge replication am im trying to alter a column in place, ive got an article from sql server cental, that describes creating a temp column copy the data over drop and recrete the column, copy the data over and drop the temp column, Step 1 exec sp_repladdcolumn @source_obj...more >>

Hi We have a SQL 2000 publication/distribution server which we wish to replace with a more reliable server. We have lots of databases with anonymous merge subscriptions to them. Is there anyway we can move the publications over without having to break all the subscriptions etc - if the ...more >>

I've got a db setup for replication. Replication works fine in both directions. However ... On the SQL2k backend, I can do an INSERT INTO to a particular table (Results) with no problem. When I try to do the same INSERT INTO on the Results table with SQLCE, I get the error message, "A dupli...more >>

From BOL : How Transactional Replication Works "After all Subscribers have received transactions, the Distribution Cleanup Agent removes delivered transactions in the distribution database. Delivered transactions are kept in the distribution database for a defined period known as the retention...more >>

Why and when to use sp_replrestart ? I heard it needs to be used when you are restoring your published database. What does it do ? ...more >>

This question has to do with SL Server replication with CRM I moved the CRM SQL Server mdf & ldf files from the C drive to the E drive following the instructions in KB872585. Everything went well except I cannot enable replication. I performed the following steps: Reopen Microsoft SQL E...more >>

We have an online shopping cart and I need to replicate the new orders out to the shoppes that will be shipping the order. I'll have about 300 subscribers that will be receiving the orders. I only need to sync each subscriber 2 or 3 times a day but I am concerned about deadlocks or con...more >>

Is there a way to drop replication on a restore. Or, is there a way to backup without saving the replication information? I tried setting KEEP_REPLICATION for false but if its is the original server the replication still shows up. I also tried running sp_restoredbreplication on the database af...more >>

Hello all! Sory for my poor English, i'm Russian Was configured transac. replication. Two days ago it was stopped (was small error - "can'not insert dublicat key"), fix error and again restart sinhronizing. After it i can see in EM next: -LogReader have status is RUNNING, but distributor ...more >>

I am in a Process of designing database deployment layout for a system. There are 4 major subsystem in the application each uses its own database. Database : 1) Primary DB 2) Processing A DB 3) Reporting DB 4) Processing B DB The Purpose of Primary is to hold all the Input data...more >>

I get this error during Merge replication " Cannot insert the value NULL into column 'nicknames', table 'REP_Sub.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT fails. " Can anyone help...more >>

Hi, the merge-agent of a mergereplication with a publisher and two subscribers stops with the message: Error number: 2147200953 Article 'TGS_LOG' failed data validation. How can I solve the problem ? Best regards Axel Lanser...more >>

Hi I want to implement transactional replication on 2 MS SQL Servers 2000 (SP3). Is there any good guide available that discusses crucial points in this endeavour (e.g. possible topologies, what and how needs to be monitored, potential issues to avoid, what to do in case of failures etc.)? ...more >>

We basically have branches at different locations and would like merge replicate the data to head office. We have difficulty in setting up the merge replication. Each location has a static IP machine on which the database resides, we are unable to create a successfull subscription. ...more >>

Hi, Is it somehow possible to merge two databases with identical schema? We have two or more sites whose data are supposed to be merged into the main database at night. Data at each site is unrelated to the data at other sites. Each site has limited bandwidth (satellite). Some sites may even ...more >>

Does anyone know why the replication conflict tables (and replication sps) aren't dropped when replication is removed from a database? Man, that's a real pain in the @ to get that stuff out of there .... ...more >>

I just started looking into SQL replication can anyone please direct me to some KB docs that I can read up on? Thanks ...more >>

If one day SubscriberA gets a push subscription, run snapshot agent, and SubscriberA goes from pending to active one the snapshot agent is done. The next day SubscriberB gets a push subscription from the same publication. It doesn't seem to go from pending to active until I re-run the snapshot ...more >>

I have a database that I'm trying to replicate to allow users to run MI type queries. This would remove the impact on the operational database of long running expensive queries. The database records details of emails including the text and is about 40 GB in size. The database is part of...more >>

My enviornment is two sql server 2000 sp3 servers. one on Windows 2000 Advanced Server and the other Windows 2003 Server. I have been able to successfully create a publication for my data files; created a subscription and everything works. (Merge) I am strugling with how to get the initial...more >>

How can i synchronize 2 tables on 2 different sql servers 2000 i mean TABLE1(c1, c2, c3, c4) and TABLE2(col1, col2, col3, col4, col5, col6) the first 3 colums are the same in two tables. anybody have any ideas? Thanks in advance -- Message posted via http://www.sqlmonster.c...more >>

How can i check if i have concurrent snapshot processing enabled thru TSQL ? I dont see an option to set it during the initial setup using the GUI ...more >>

Trying once again as I did not get an answer before.. Maybe you guys did not see it.. 1 ) It seems like with sp_reinitsubscription, I can reinitialize a particular article which may not be possible using Enterprise Manager .. is that right ? Im just thinking of the possibility of using it say...more >>

Hello Last week I made changes in our Merge replication. After adding back the subscribers, when trying to delete rows I started to get error message "Cannot insert duplicate key row in object 'MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone'" I found few posts regarding this pr...more >>