I am trying to run the sp_replicationdboption stored procedure to start setting up replication. My query looks like this : exec sp_replicationdboption @dbname = N'Manual', @optname = N'merge publish', @value = N'true' However I get an error of: Server: Msg 20028, Level 16, State 1, P...more >>

Resubmitting with the correct e-mail domain... The problem I'm having is that prior snapshot folders are being retained on my production server and the unc folder is growing quite large. This is different behavior that what is occuring on my acceptance and development servers, where only the ...more >>

What port is used for merge replication? The same as clients uses to connect to SQL Server ? -- Best Regards Wojciech Znaniecki ...more >>

hi all, im concerened that when then snapshot agent runs on my publisher this will lock the tables, and i cannot guarantee that there will be a regular period of downtime when i can run with the tables locked, what are the implications of running my merge replication with the snapshot agent ...more >>

Hello, This projects needs to setup automatically a few MSDE subscribers to a main Distributor/Publisher. I am using the ActiveX SQL Merge object to set up the merge replication, but there are 3 problems: 1) There is not a property to set Continuous mode 2) If I set the ExchangeType to u...more >>

When I create a publishe and distributor and I set the snapshot location to a network accessible drive for the subscribers to be able to access. I get errors stating that the script was unable to run and states a different directory than the snapshot directory. Where to I set these directories a...more >>

Hello, I am logged on my machine as my own user id and password. I connection to two other machines Server1 and Server2, both have there own user id's and passwords to start and stop the SQL and Agent Services, I am an administrator on both machines. My problem is I cannot start up the d...more >>

I hava a scenario where I have an SQL Server set up as the publisher (merge) and the subscribers are Laptops with MSDE which work mostly offline. The subscribers are updated once they are online with the publisher. My question is: How can the subscriber tell if the MSDN database has finished t...more >>

updating publicatgion DB base on subscription DB changes, is that possible to do? and how can we make sure the orders? cheers ...more >>

Dear All We have a publication on Server 1, using Transactional Replication. Server 2 has the distribution database, and the database we are replicating too. We switched off the publication using EM Tools -> Replication -> Disable Publication and Distribution, and attempted to change som...more >>

Hello all, I'm trying to figure out what type of replication I should use for this scenario. 1. I've got a table of about 50,000 records that I want to replicate to a remote database. 2. The database will need to be in a production state during the transfer of data so that our customers...more >>

We are using merge replicaiton and will do A publisher to B, C and D E publisher to B The data of A and E are same. B, C and D are subscribers. The reason for this, we just want to test E and it will replace A later. Please let me know if this possible. Thks ...more >>

Hi, One of our subscriber server is full due to transaction log too large. The replication was failed without no space for the transaction log. My question is can I delete the transation log? Or is there any way I can free some space on that subscriber server? Please help me. p.s. ...more >>

I have a web application coded in dotnet and ms sql server. It is a multiuser system that lets members search for other members via their profile fields. It gets complicated in that it lets users search based on distance from a zip code, as well as degree of separation. However every time I ...more >>

Hi, I am trying to detach a database to move to another locaion on the same machine The database has replication. I get the following message: Cannot detach database while being replicated. Any Idea how to detach database without removing replication. Thanks ...more >>

Sync data between OLTP data tables and OLAP fact tables. I have my data in several data tables, I had built a view to aggregate the data from these data tables. This view is similar to a fact table in OLAP Analysis Services except it has no Fact ID (PKID). My OLTP Database in Server...more >>

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 >>