Hi, I am using a SQL server table in my Java application. I want to prevent reseeding of the identity column. Table T1: C1 INT IDENTITY NOT FOR REPLICATION PRIMARY KEY, C2 VARCHAR(100) Say I have values: 1, 'abc' 2, 'xyz' I can explicitly insert a value for C1 into this table by : SE...more >>

Hey guys. I want to implement merge replication and I know I've to implement dynamic filters based on user logins (suser_sname()). Anyways, the problem comes in here: I've to create a publication based on username where the users who login with certain usernames will point only to their row...more >>

I´m sorry, my english us very bad, so i try to explain my problem Hy, when i try syncronize SQL SERVER CE x SQL SERVER 2000, this message "Initializing SQL Server Reconciler has failed. [,,,,,]"...shows up in pocket pc application (csharp).. Anyone knows how can i fix this ? Thank´s ...more >>

Hey. I have transactional replications etup on 3 tables of a db. These tables have 181 million, 95 million and 100K rows respectively. They are rplicated using Transactional Replication, one way only. We have filegroups created for index and secondary files for data created on the publisher. O...more >>

When is Hilary Cotter's merge replication book going to be published? ...more >>

Hope somebody can help because this is rather fustrating. I have recently been doing some replication configurations between two servers. I started to get a warning symbol on the replication monitor so I decided to uninstall replication and start again. Unfortunately when I reinstall replicati...more >>

Hi All! I want to know if a DB on SQL 2005 can be subscribed to a SQL Server 2000 DB. Will it works fine? Also let me know any documentation about the SQL 2005 Replication. Thanks and Regards. ...more >>

Hi all, When we right click a replication agent, we can see error details tab. But in some cases the tab is disabled and in some cases it is enabled.I'm curious to know under what circumstances it is disabled and under what circumstances it is enabled. Thanks in advance, Preeths. ...more >>

Hi all, We have 2 merge replication jobs. I want to complete one job and then start another job after the first one is completed. Is there any way, that I can make the first job to trigger the second job as soon as it is over? Thanks in advance. Thanks, Preeths. ...more >>

Used the Wizard to Creat Publication for the first time. I saw three choices "Snapshot publication", "Transacional publication" and "Merge publication". I wanted to slect "Transacional publication" but it was grayed out. I wonder why!! Created a database with one table on server A. Cre...more >>

I need help, replication error The process could not execute 'sp_repldone/sp_replcounters' Thanks Carlo Sorrel ...more >>

Hi everybody, How can i add a field in a table which is involved in a Transactional replication. Thanks, MAtthew...more >>

I have a merge replication setup. Some time back i removed a table from subscriber which was in replication . I have included the table in replication again. How to synchronise the data in this table? I can not use sp_addtabletocontents/sp_mergedummyupdate because not only the data is hu...more >>

Some of the sp's used by replication to do insert/delete/update are = missing in the database being replicated to. If I reinitialize the snapshot will the missing sp's be generated? Do you have any idea as to why the tables (Schema & Data) were setup = during the snapshot but some of the sp's ...more >>

Hi All, I am a newbie to MS SQL Server 2000 but I really need to solve this issue: We need to daily replicate all databases within our MS SQL Server 2000 to another MS SQL Server 2000 - the amount of databases is not fixed because new databases are created on a daily basis. --> Is it pos...more >>

This may seem like a trivial question, but what's the point in allowing merge subscriptions to expire. True, the time can be set on expiration, but nonetheless, you may have PocketPCs out in the field for an indeterminate amount of time. I'm just wondering why in the first place you would EVER...more >>

Hi Guys, I have been playing with dynamic filtering in merge replication and I have a question about its behavior. What I have done is to use a user defined function to evaluate SUSER_SNAME() and return a list of ids by which the records should be filtered for that user. Every...more >>

I am trying to set up replication from a remote server (YYYY) to a server (XXXX) on my company's network. The remote server will be the publisher and the local server will be the distributor and subscriber. It gives me the following error when I configure the publisher and distributor : SQ...more >>

For a snapshot replication. I set the Name conflicts from the defualt-DROP the existing tables and re-create it to Delete All data in the existing table. and set check in Include declared refertial integrity in Copy objects to destination secton. After I close these perperties window and...more >>

After the initial snapshot had applied manually and snapshot agency stoped. Then I deleted the tables and stored procedure at subscription databse. I restart synchronizing, Sometimes the distribution agent moves the snapshot from the distribution database to the destination tables ; Someti...more >>

Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional database, DB2 also on Server A derived from DB1. Since the DB1 is frequently updated the synch...more >>

How can I replicate SharePoint Site to other SharePoint Site? Does SharePoint Portal Services support replication between two sites? Any help is much appreciated. Thanks...more >>

I restored a db to a new server, executed the following; exec sp_removedbreplication 'ADAGE' go exec sp_dboption 'ADAGE', 'published', 'FALSE' go exec sp_dboption 'ADAGE', 'merge publish', 'FALSE' go Yet, the ADAGE db still has views like sync% Did I miss a step necessary to remove a...more >>

SQL 2000 When changes are made to stored procedures at the publisher, the changes are not replicated to the subscribers. I have verified that the stored procedures are marked for replication. The end result is that users of the data on the publisher see different data than users of the dat...more >>

Greetings: Does anyone know if I can install/run the Log Shipping Monitor Utility on SQL 2000 Standard Edition, or do I need to actually have THREE copies of SQL Enterprise Edition in order to configure Log Shipping? I realize the recommendation is to NOT install the monitor utility on the ...more >>

Hi I'm in the process of working out how we are going to set up replication for a client. Quite a daunting task. I'm think we are going to use Bidirectional Transactional Replication, as described here: http://support.microsoft.com/default.aspx?scid=820675 If you look at the sample you w...more >>

Hi All As we know since SP3, the login security password are not even stored in the registry when using WSM. I saw that when adding the SubscriberEncryptedPasswordBinary in the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions\my_subscriptio n] WSM ...more >>

I need to copy an installation to another server without breaking merge replication on the existing database. Is the best approach to simply script out the database, do an export of the data, then recreate on the other end and set up a new publication? ...more >>

I have set up Merge Replication and everything is fine until a subscriber goes offline for any length of time. The issue has to do with the setting of the @identity_range parameter for each article. I am configuring the publication through the SQL Management Studio (server is SQL 2005) and ...more >>

Hi Guys - I have some basic questions about horizontal filtering and would appreciate any help. Dynimic Filtering When I create a snapshot of a publication that has dynamic filtering, what will it include? In other words, when the subscriber synchronizes for the first time, w...more >>

we have set up merge rep and it is working fine. i have setup alerts if rep fails. recently i am not getting these alerts what would be the reason how to configure alerts...more >>

Dear all, I want to add a new server as a publisher to an existing distributor, but each time I try, I get this error: Could not find stored procedure 'dbo.sp_MS_replication_installed'. I also tried making this machine it's own distributor, but the same error comes up. :( Thanks in adv...more >>

If my replicating db has an .mdf/.ndf/.ldf, with some tables being = located on the Secondary Data File, should I change the schema of the = replicated database to match the replicating db? Does it matter? Would it be a 'best practice' to have both database = schemas the same? I didn't set...more >>

I have successfully setup log shipping between my production SQL 2000 Server (setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a WAN) What is the best way if any to stop the log shipping for a extended period of time and re-enable it without setting up the entire maintenan...more >>

I am doing bi-directional replication between SQL2k and SQL7. How can I turn loopback detection on? I have been looking for documentation and found sp_replsetoriginator, but it doesn't talk about how it can be setup. Thanks. -A ...more >>

We have a publisher and 2 subsribers. The subscribers are spanning 2 transactions/sec. We have implemented merge replication and it was scheduled to occur every 5 min. When we ran it for the first time with a transaction rate of 75k/hr it ran for 4 days.After sometime we got problems so w...more >>

I have a few questions. I'm going to implement Merge replication on a very large db. This is how the client wants it implemeneted. They have a few databases but i'll be working with only one. It will either have 10 publications for each customer + 1 publication for the rest. OR It can hav...more >>

Hi guys, I'm fighting against Merge Replication in SQL Server 2005. I've tried several times to setup merge replication with a real example but I can't. I've followed this instructions given by this "article" in MSDN2 but there is no way: http://msdn2.microsoft.com/en-us/library/ms171908.as...more >>

Is there an equivalent of CHECKSUM from SQL2k in SQL7? I discovered getchecksum in SQL7 but I can’t use it since the tables in the subscriber are denormalized. Thanks. -A ...more >>

Scenario. A db published for transactional replication will be backed up and restored on a server in a different facility. There, all new replication will be defined (completely different articles, completely different targets) Question. Will pre-existing replication prevent correct ...more >>

Greetings: I have been asked to set up replication between two SQL servers on our network. Though I am primarily a network security engineer, and would consider myself just above a novice SQL Admin, replication is definitely new territory for me, and I was hoping I could get some help and fee...more >>

When I am running sp_addpublication, I am getting the following error. Whats wrong? I was able to run the same script before and this stored procedure was running fine. Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24 Supply either @job_id or @job_name ...more >>

How do I add a table to a replicated database using the Enterprise Manager? I know to use the Publications properties to add a column, but want to be sure to add a table correctly. ...more >>

Hi All If the Snapshot agent is suspect, what does that mean and how do i resolve that problem? Thank you in advance. ...more >>

I'm working with VS.NET 2005 Beta2 and SQL Server 2005 April CTP. My SQL Server 2005 installation was more or less full, that is, I installed everything related to Client Connectivity. I was bound to build a merge replication scenario when I've noticed I needed "SQL Server 2005 Mobile Edition Se...more >>

I've done this at least 50 times without issue on various databases, but this one just doesn't want to play nice. So I have a SQLServer2K database setup. I've got a home-grown disaster recovery process in place, so that transactions are taken from one server and migrated to a backup server...more >>

Hi, I am trying to setup my merge replication to use Alternate Replication Partners. What I want to do is to have PubA as the main publisher and PubB as a named pull subscriber to PubA and a republisher. Then, there is SubA, which subscribes to PubA (pull/anonymous). It works fine. I c...more >>