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