I am trying to separate two applications sharing the same database and a few tables(like t_employee) in a phased approach. How can I best setup a bi-directional update of this t_employee table when updated by either application? Thanks, Memphodave -- Message posted via http://www.sqlmonster...more >>

Hello, For political reasons, I need to havec datas stored both on a SQL Server 2000 and a Sybase ASE v12. If data changes in SQL, it must be replicated to the Sybase server, and if data changes in Sybase, it must be propagated to the SQL Server. Do you know how can I reach my goal in a s...more >>

Is it possible to have a pull subscription and then have a pull subscription of that subscription? We want to have a server wich replicates to 2 or more laptops wich will be replicated out to 3 or more ppc all running sever - msde - sqlce? ...more >>

Hi, I have 2 different subscribers for the replicated database. What I want is that do is to provide subscribers access to different tables i.e. if Table "A" is on Subscriber1 machine I want Table "B" on Subscriber 2 and replicate them with publisher. Is it possible? Thanks ...more >>

I want to update SQL Server version from 7.0 to 2000 but my installation is replicated in another 7.0 SQL Server instance. Can I update only the first? Will be there any problems? Thanks enzo giurleo...more >>

Hi I have Merge Publication with just one Subscriber running on SQL 2000 which has been Service packed fully. Looking at the previous posts I did uncheck 'Enforce relationship for replication' on the Table Relationships hoping that the deletion of records will not happen. But for some u...more >>

Hi All, Setting up transaction based replication or merge replication bi-directionally forces me to use a unique identifier. I want to manage primary keys and the allocation of number ranges my self; but it seems I am forced to use the uniqueidentifier with my schema - I do understand why ...more >>

hi there: i got a big problem here. i call serval store procedures from c# to drop a republication. the code likes following use [databaseName] GO -- Dropping the merge publication exec sp_dropmergepublication @publication = N'database_Publication' GO -- Disabling the replication dat...more >>

I want to formulate a comprehensive disaster recovery procedure for my system. I am running two SQL 2000 servers with replication. I find that some of the Microsoft literature a bit patchy for what I want. Can anyone tell me of any good reference text that are available that concentrate mainly o...more >>

Hi I have a SQl databse on a web hosting server, and I have the databse locally on one machine, I'd like to know if I can synchronize the data between the two server. In other term, I want the data locally to be updated every day, with the data in the web hosting server Thanks...more >>

Is it possible to set up replication from Single-Filegroup to a Multi-Filegroup? Thanks,...more >>

Type Replication: Merge Type Suscriber: Pull 1 Server Publication 5 server Suscriber's after a reinicialition on one Server suscriber, all data from Publisher was transfer to the suscriber, but once I trie to insert records, send this error: [Microsoft][ODBC SQL Server Driver][SQL Server]...more >>

I have a database working with Merge replication, there could possibly be a audit database associated with this replicated database. After talking about it we decided it would be better to have each subscriber database have a copy of both the replication database and the audit database withou...more >>

Hi, I created a new table on the publication database the owner of the new table is not dbo. We then called sp_addmergearticle to add the article to the publication, using the @source_owner and @destination_owner parameters to specify the owner is different from dbo, and the @force_invalida...more >>

Hi, Is there a way that I can set up an email notification that can notify me whenever there is a conflict during replication? Thanks ...more >>

Hi All, I have Sql-Sever 2k SP2 and Win2K SP4 Advanced server. Topology : Republisher Publication Type : Merge with dynamic Filtering. Everything was working out well after setting up that topology but suddenly , after some hours happened what follows : Error on the Publisher : Failed ...more >>

did Anyone implement Merge replication over internet? and wht were the results, i need a detailed procedure of implementing replication over internet, i have successfully implemnted on the LAN but its not working on internet, i'll be thankful if u guide me. i am using a 128 ISDN line. What i want to...more >>

I have a server work as publisher and distributor for a database and another remote server work as subscriber. The remote server downed and reformatted due to system failure. We setup another remote server with different name. But when I tried to disable publishing/ delete and recreate subscri...more >>

Hi, We are trying to configure sql server 2000 transactional replication across 2 data centres through vpn and firewall. While port 1433 is open for sql server communication, it looks like the anonymous pull subscription uses a different port to download the initial snapshot files. We are ...more >>

Does that sound right? Now what is happening is that all the transactions that were waiting behind that snapshot are so far behind I am afraid we will need to reinitialize those? tia...more >>

We have a large legacy application built in MS Access (front-end client mdb with back-end shared data mdb) and are looking for a good migration path into SQL Server. The problem is we can't fund a large effort and are looking for a more gradual migration path. To me the ideal path would requir...more >>

I know you can have SQL Server email you when a replication agent fails, but we had the following situation: schema change on table broke replication of that table only, but none of the agents failed. Even when I noticed that table wasn't being updated, when I went to add that article, it ...more >>

Hi , I recreated all the subscriptions and now I am getting error for one of the tables The merge process could not retrieve identity range resource for table Please help ...more >>

Hi, I am trying to do Merge Replication between SQL 2005 and SQL Mobile Edition. I did set up Publication and Distribution successfully using SQL Server Management Studio but when I tried to create a subscription from SQL Mobile Database then it asks for Web Server Authentication where I nee...more >>

I have a merge replication environment with 1 publisher/distributor in the same machine and 3 subscribers with a lot of data to merge. The link between them is slow. I'm with performance problems with my applications I think that job replications could be punish this performance. Setup another ...more >>

Hi There, I created a merge artcile and forgot to set auto_identity_range as tru and now I want to set it. Can any one suggest how can I achieve this? I tried this ... sp_changemergearticle 'LPAPP', 'KitAllocation', 'auto_identity_range', True It did not work. Thanks ...more >>

Hi, I do not recall if snapshot replication allows no data replication. If there is a dummy filer that need to be placed on each objects I guess it mgith be possible? However, I am not sure if the dummy filer will cause a performance issue. On top of that, we have databases with a lot ...more >>

Hi all - I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used under it at the host. I can get at the db by using Access/ODBC with a URL but the migration facility seems only to let me get at the tables. There are about half a dozen SPs referred t...more >>

I set up a transactional push replication and basically would like to use the subscriber as the archived historical database server. Once the snapshot is completed, I would like to delete old records on the publisher article and not replicate the deletion onto the archive database server. ...more >>

after I replicated two project server database in two sql server, I don`t add new user or modify old user in project server,Why????????? and another my problem: How replication with Dial-up connection(I replicated with LAN)????? Please help me Thanks Bita -- Message posted via http://www....more >>

I followed the directions from a previous post by adding a 4th step and changing the 3rd step to continue with success. When I applied the new change I got a warning that the 2nd stop and the 4th step both had quit with success, I ignored that warning and had a change on the subscriber propag...more >>

Hi I want the last change remain, when I have a conflict between subscriber and publisher.it means that I want the the earlier always win (the data type is not datetime) whether it is publisher or subscriber, what must I do? ...more >>

After a subscriber connects to the network and merges the data with the publisher I’m looking for a way to trigger a script to run. Is there anything built into SQL Server to do such a thing?...more >>

Hi, I get the following error when replicating.... ODBCBCP/Driver version mismatch (Source: ODBC SQL Server Driver (ODBC); Error number: S1000) ---------------------------------------------------------------------------- ----------------------------------- what could be the cause... ...more >>

Hello. I have problems in merge replication from SQL 2000 (dev.edition) to SQL 2005 Express. I did all things mentioned in BOL (for Express) to setup pull subscription. But when i try to start MergeAgent for Express - i recieve "Login Failed" error. Account running Express version seems to...more >>

hi, I have created merge replication on the server and pull subscription on the client. When i try to start synchronising the pull subscription i am getting the below error. The process could not enumerate changes at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error num...more >>

How do I sort out what is shown in the Replication folder in Enterprise Manager? If I look at the subscriptions in the Publication folder it lists correctly the 22 servers. But in Subscribers it lists 29 subscribers that should not be there. The ones that I expected to not be there are not sho...more >>

Merge replication. Push New Subscription. Immediately after I click "finish" in the wizard (push new subscription), the subscription status shows deactivated. The merge agent runs and completes then shows status has failed. error = "the subscription to the publication pub_name is invalid....more >>

Greetings: Can I remove replication using Enterprise Manager? Thanks for the help -- sam...more >>

Hello everyone I have set-up SQL Server 2000 transaction replication but its only working one way? Data entered at the subscriber database is not making its way to the publishing database? I have Defined the distributor, Defined the publisher, defined a publication, created a push subscript...more >>

I am updating rows in a particular table in my sql ce 2.0 database. After I synchronize with the publisher, the updates are gone, as if I had never changed the rows to begin with. This is only happening in one table in my database. This table's primary key is a foreign key in many other...more >>

I have been asked to replicate data to an externally hosted web server which i have managed but i cannot get the stored procedures to replicate, is this possible? thanks in advance. ...more >>

HI All, My Sceneario: Sql-Server 2k SP2 , Win 2K Advanced Server. Topology : Central Publisher Publication Type : Merge - I've set up my Publication to use FTP. The Snapshot files are generated well.I've set up in the Client Network Utility the Server Alias, the Server Name (IP addres...more >>

Hi, I have the following scenario: There are two databases Server1 and Server2. Server1 would have to be an exact replica of Server2 as far as schema is concerned. Data need not be the same. The reason is some application would be doing data manupulation on Server1 and therefore the need is to...more >>

Merge replication on SQL Server 2000 sp3 and Win 2000 Pull subscription with MSDE. The subscribers need info on replication status. I query MSmerge_history and MSmerge_agents with a join on agent ID. I would like to filter by subscriber_name, but this field is empty for each subscriber. I...more >>

Dear All, I guess I am pretty much a green to this on replication - I have been running merge replication for a while and have had it working but now get the following errors on all replication tries when it hits the table RoadmapVersion. 1 Processing article 'RoadmapVersion' 2 Categor...more >>

I have a primary DB named FactoryA and a secondary DB named FactoryB. I need to sync seeveral lookup table in FactoryA to FactoryB if lookup table in FactoryA is updated. I never update lookup table in FactoryB. You may assume that lookup table in FactoryB is a replication of FactoryA. ...more >>

Hello everybody, i need to set a MSDE database as 'publisher' for merge replication. My difficult is that I haven't understand how I cand do it. I have not Enterprise Manager for set the merge, How I can Do it ? Thank you so much, ...more >>

Hi group I have the following setup: A primary sqlserver running windows 2000 server OS a secondary sqlserver running windows 2003 server OS Both sqlservers run sqlserver 2000 software, and both logon with the local administrator account. Both administrator account have the same password, so...more >>

I have replication servers accross the ocean but the data volumn is so high that on subscriber site the data is always delayed. I have followed with BOL and changed the replication parameters like -b -c -packet -buffer -OutputVerboseLevel etc but not enough. I have traced on network, the n...more >>

Ohhh. there are non problems on weekends or what? dt ...more >>

How can I configure SQL Server merge replication to work in only one direction? only changes at a subscriber are sent back to a publisher. Thank you....more >>