Is it possible to synchronize schema objects changes between publication and subscription by starting snapshot agent whenever add/delete/update tables/columns occur without re-establish publication? ...more >>

Attempting to set up a one-way transaction replication for a Microsoft Business Solutions Great Plains database. Unfortunately every table in the database is configured with an identity column. My replication work fine after the initial snapshot but fails everytime after that. The error me...more >>

Dear Friends I am working on Merge Push replication and the same is based on VPN connection. when the VPN connection is down the replication do not find the subscriber and the same is failed now when the VPN is connected i have to activate the replication manually i want that the repli...more >>

I get an error: Could not bulk insert. Bulk data stream was incorrectly specified as sorted. (Source: CMTSQL2 (Data source); Error number: 4819) The BOL tell the exact same story when searched for this error number, how do I solve for this issue? Thanks in Advance Kinda Lost ...more >>

I keep getting an error when I try to set up a merge replication... Cannot insert duplicate key row in object 'TRDFIL' with unique index 'ITRDFIL0'. (Source: CMTSQL2 (Data source); Error number: 2601) I can't seem to figure out how to prevent this from happening, any ideas on what is not co...more >>

I create successfully a Merge Publicaition via ftp server and a anonymous subscription after that start synchronizing at subcripber, it runs very well until it uploads data changes at sub to publicaition, it's failed: Failed to enumerate changes in filter articles. what happened? plz hel...more >>

Merge Replcation has a error: Failed to enumerate changes in the filter articles. Why? how to fix it? ...more >>

I'm trying to figure out how I can alter the size of a column (e.g. increase a varchar(10) column to varchar(50)) when the column is part of a replicated column. We use merge replication between SQL2000 and SQLCE on PocketPC devices. It is important that the subscribers be unaffected by the...more >>

I have a merge subscriptions containing dynamic filters based on the sUsers_sName function. So in that case I can use the dynamic snapshot wizard. The snapshot is successfully build on the server but when i try to create the pull subscription at the subscriber i get violation of primary key dur...more >>

Before going through the motions of attempting a merge replication just thought I'd pop the question here rather than waste hours in the impossible as is often the case with SBS and links to other SBS systems. Is merge replication possible between 2 SBS 4.5 systems over an adsl connection? ...more >>

Hello all, I use to have a named subscription then for an reason I delete it. Now I am trying to create an new anonymous but I get the following error: Category:SQLSERVER Source: Number: 21500 Message: Invalid subscription type is specified. A subscription to publication 'myDB' already ...more >>

I have a problem that seems to be a bug in SQL Server. We have a database that is in merge replication with 5 subscribers. The platform is SQL Server 2000 SP3a running on Windows 2000 Server SP4. The problem occurs in tables where columns are added through the publication. We added a colu...more >>

Hi all, I have a stored procedure in SQL server 2000 that creates a merge publication. This stored procedure is to be called by a .Net application. Whe we call the stored procedure we receive the following error "A severe error occurred on the current command. The results, if any, should be discard...more >>

Please HELP, It is impossible to create a Publication . When a tries to do that I always run up with error 515. "Can not insert the value NULL into column 'step_name' table 'msdb.dbo.sysjobsteps'; column does not allows nulls. INSERT fails" I have tried everything to solve the problem but...more >>

Hi, I am trying to setup replication between 2 SQL Servers across non-trusted domains(2 different domains). I am able to successfully registered both SQL servers in either domains. But I still cannot access the snapshot folder in the Distributor/Publisher domain from the subscriber domain. * I'...more >>

Dear All Hi Subscriber is not working. While if i am creating subscriber on same server then working ok. I have created Server A as Publisher and distributor, have db ExPlus, if creating push subscription to Server B then not working while if creating push subscription to Server A then working fin...more >>

This is probably a newbie question.. I have a published database with lots of stored procedures in it. When a procedure is CREATEd I publish it as an article, create the snapshot and after the next merge my subscriber databasess have the new procedure If I ALTER a procedure, create a snapshot and...more >>

I have a publisher on SQL2k and two merge subscribers running MSDE on laptops A table (TextLines) looks like thi TextLineGUID uniqueidentifie TextLIne varchar(200 TextOrder in The most common query looks lik select TextLine from TextLines order by TextOrde In order to swap two TextLine rows...more >>

Hi, I'm a newbie on SQL Server. I'm tryn' to make my first Merge Replication, while I create a publication for Northwind, then a message shows "Cannot verify snapshot folder" (\\TRIBALZ\C$\ReplData), then I answer Yes to Ignore. Next step, I make a Virtual Directory via SQL CE Connectivity Tool,...more >>

I would like to use sync manager at our remote sites for scheduling merge replication. I'm using dynamic filters and don't see where I can set the -hostname for my subscriptions from within sync manager. Am I missing something? Thanks in advance for everyones help. ...more >>

Hi, We are using transactional replication with queued updating between SQL2000 Servers SP3. I have the following problem. Queue Reader Agent is aborting after trying to execute commands from one of the subscribers. (If the subscriber is not online, it works fine.) The error is: Server: ROM...more >>

I can't quite figure out how to add the range check CONSTRAINT on subscriber if I already have data in it that came from the publisher that doesn't meet the constraint. Example: Publisher = Range 1 - 100000 Subscriber = Range 100001+ I already have rows in my Codes table WHERE ID BETWEEN ...more >>

We'd like to deploy a central subscriber architecture -- many publishers, one central subscribing server. We see this as using transactional replication -- as we require continuous updates to our subscriber. As we deploy new publishers, how do we protect the new snapshot -- which seems t...more >>

Hi All, I have set up Transactional Replication with queued updating as subscriber. I am testing recovery of Publisher database, then i am getting strange errors while restoring. Is Replication should be disabled for Restoring The Publisher database, Or Just stop all agents will work. Please advi...more >>

Hi All, Back in January I added an Article to one of my Publications running SQL Server 2000 SP3a with MSDE, and have had all my field force communicate, however in the last couple of days, I am now seeing this error:- The process could not enumerate changes at the 'Subscriber'. (Source: Me...more >>

I have a production server acting as the publisher/distributor to various subscribers. I want to setup another server for testing to replicate the production server. This will be a one way replication from the production to the test server only. I also want the test server to act as a publ...more >>

Hi I am getting the below error message when I am trying to restore a database. This error occurs after I installed SP3 Error Messag ======== Could not find stored procedure 'dbo_ss.dbo.sp_MSremovedbreplication' Could not adjust the replication state of database 'db_sss'. The database was su...more >>

Hi I'm using Merge Replication in SQL2000 sp3a. I've successfully set up Dynamic Snapshots using "Custom File Locations" (The option with the Dynamic Snapshot checkbox in Subscriber properties) in my test environment. I have to use Dynamic snapshots over FTP though, as we have a lot of site...more >>

Here's the situation, I have three servers, Server A, B and C. A is the publisher and distributor, B is the subscriber (merge replication) and C is the hot standby A ------ (merge replication, push subscription) -----> B | | (log shipping) ...more >>

I have two SQL clusters with two servers in each (DB01 and DB02 in Cluster01, DB03 and DB04 in Cluster02). I need to replicate this clusters in real time DB01 <-> DB03 and DB02 <-> DB04. Updates are happening to both clusters. For example on DB01 and on DB03 I have databases, with Posting ...more >>

I'm looking at the permissions on the tables conflict_* and see that all users do not have any permissions. What permissions should be on these tables ? -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

What solution do you use to restart log reader agent automatically? i have subscribers connecting distributor on ADSL, sometimes ADSL is down and the log reader agent fails after ten retries to connect and does not restart. i'm trying to use an alert on 14151 to restart the job does someon...more >>

How can I set up Merge replication so the subscriber can not change any data, they can only pull down changes from the publisher? Thanks. -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

We have a timestamp column used by development on each table in our db. In past testing of replication, I believe there was a problem with this, since SQL wants to add a timestamp datatype column to manage trans replication Are we forced to remove our timestamp column from each table, in order to...more >>

Hi - I am facing serious issue when replicting the DBs. let me put in this way. I am new to replication concept. I created publisher, distributor and subscriber. till this point every thing is fine. but data is not replicating I even analyzed the problem. data is not replicating since I don't have ...more >>

Hi I am new in Microsoft SQL Server replication. I found out that all the relationships and primary keys in the subscriber's database are dropped. I create the database for subscriber during the push subscription process. Is there anything that I've overlooked? or any other way I can preserve the ...more >>

Hello all I had replication set up where I was replicating one database with across two sql servers. Then the server holding the publisher database went west and now the distribution database on that server is suspect I cannot drop the database as it says it is being used in replication. Howeve...more >>

hi all, i am beginner of sql 2000 replication , how to make simple setup between two servers . second, can i replicate database between two servere one of then sql server is not installed or not active ???...more >>

I have a transactional publication for which all subscribers already have the data, and therefore for which I do no synchronization. I am using custom procedures to replicate the data. The first time I ran a few update statements against the publisher the wrong version of the custom procedures...more >>

I'm trying to set up the dynamic filters within my replication design, but had no luck so far. This is how I'm doing it now. I have one publisher/distributor, and I have two subscribers. The table I'm replicating (let's call it replTable) has a column named orgId. I want all the rows with the ...more >>

I have a SQL Server installed upon a Windows 2k Server Domain Controller with Active Directory. SQL Server is setup in Mixed mode authentication, and at present SQL Server/ Agent starts under the NT account. How do I get it to start under SQL logins account. What are the steps, please list the st...more >>

Hi, i configured in sql server a transactional replication (pushabo). the replication starts automatically once every day. it is also possible with the enterprise manager to start the replication (synchronise) manually. I am looking for a solution, to start the replication from a webapplic...more >>

Hi All, I'm setting up the following replication topology for my company. I have three types of tables, each of which have different replication needs. Each subscriber will be running MSDE and will be using a dial-up connection to the Home Office. To start with there will be 6 subscriber...more >>

Hi, I got error when I created snapshot replication, same tables name belongs to different owners. The first table was added to replicate article but second table failed whit following error: exec sp_addarticle @publication = N'JDE_PRODUCTION', @article = N'F91014', @source_owner = N'P...more >>

I readed in a book that it is possible to publish as an article stored procedures results , but there wasn´t any info about how to. I have been searching for info about this with no luck. Is that true? How can you do this?...more >>

To have two SQL servers in different domains, non-trusted to replicate with each other, do they have to be installed upon a Windows 2K Application server without Active Directory? Or is it possible to install SQL server upon a Windows 2K Domain Controller(Server with Active directory installed). ...more >>

Any idea why I would be getting the above error? Detailed information suggests that the 'User does not have access to one of the tables' Any ideas please ? -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

Hell I am a beginner in SQL SERVER 2000 and I am tryng to make my first replication. I don't know how to begin with ...more >>

Line 40: Incorrect syntax near '@@ERROR'. (Source: SERVER (Data source); Error number: 170) I received the error above while creating a snapthot for a merge replication publication. The pub replicates 20 tables to a subscriber and the distributor resides at the publisher. What could be the...more >>

In what system table can I find links between job names and merge subscriptions? Mike -- "I can do it quick. I can do it cheap. I can do it well. Pick any two." Mario Splivalo msplival@jagor.srce.hr...more >>

i have a strange problem : i have an editor, one distributor and three subscribers several publications (merge and transact) Several publications have the same schedule on (only) one subscriber, for merge replication (pull), and only sometimes, the first distrib agent on subscriber (some...more >>

Is there a stored procedure that will actually update the sp_Msins_??? stored procedure instead of returning the script to do the job? If not, has anyone developed a T- SQL script to execute the ouput of the sp_scriptinsproc? Thanks ...more >>

Hello! I'm trying to add new table to trasactional replication via T-SQL commands. I've created a table, and now I want to include it in publication. Here's what I did: exec sp_addarticle @publication = 'iswitch_publication', @article = 'test_table', @source_table = 'test_table', ...more >>

Hi All, Greetings. We have succesfully setup Transaction Replication In our Test Environment between two datacenters. We are taking Every Hour TLog and Daily Full Backup. Please advise me the steps to restore in case of damage Publsiher database, subscriber database. I want what precautions shou...more >>

I am planning on setting up a server that will have copies of my databases. I believe that using replication (transaction) would be my best bet. The data needs to be close to real time. The question that has been raised by others in the group is how much stress will adding replication to the ...more >>

Hi What are the steps need to be taken to enable SQL merge replication using SSL? Client side database has MSDE on Win2k Professional and server side database has MS SQL 2000 on Windows 2003 Regards Rajesh ...more >>