Hi, We are planning to replicate our bussiness database on some of our branches for reducing response times for these sites. Branches will merge it contents at night with our central database, just to avoid the overload of our main server at day. We are planning to deploy around a dozen of sub...more >>

Hi, After deleting the Merge Publication from Replication, Publications, there are still remains of the publication in the database. (the rowguid column in every table and the shared sign on the database icon) We would like to remove them without creating a new database. It looks like runni...more >>

Hi, I have a replicated to table. It has the ID column as unique and I want it to convert it into non unique. How can I do it? ...more >>

I would like to setup log shipping for only a select number of tables within my database. Activity would be happening on a number of tables, but I only want to ship the transactions/logs for specific subset of the tables. Is that possible with MS Log Shipping or another 3rd party tool? ...more >>

Hello ... I am having a problem ,, where my replication is not working .. i.e i cannot see the data in the subscriber database.. i think i am missing something.. the below is my system setup and the steps that i have folllowed.. can u know if i am missing something? Here is my sql syst...more >>

Hi Everyone, I have an application set to merge replicate the MSDE (on remote machies) and SQL (on Server), once the user logs on or logs off the application. What I want is to set the replication so that the database replicates even if the user is not logged on to the application. At the mom...more >>

We have a Publisher and a Distributer in a remote location and a Subcriber in our office. After initial snapshot, we added triggers to some Subscriber's tables, but everytime there is Reinitialization on the Subscriber, we have to recreate triggers. Is there a way to reinitialize and not loos...more >>

How would I set up secure replication between 2 servers that are in different cities? I need just one way (snap shot) push. Would I use SSL or VPN? Help appreciated. Thanks. Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewar...more >>

Hello, I've merge replication set between SQL Server 2000 & SQL CE. Whenever I try to add filter clause to the existing publication, it gives error mentioning the column name used in the filter clause. Ex. Let's say I've 5 publications - Pub1, Pub2, Pub3, Pub4, Pub5. If I add filter clause...more >>

I have perform merge replication in the SQL server with access database, however I would like to change the database schema in the SQL server. How can I do that? e.g. such as adding a field in the table or changing the data type of the column field. Thank you Regards Jabba...more >>

I'm currently exploring ways to perform merge replication between MSDE and SQL Server 2000. Synchonization Manager is of interest but I'd like to clarify a few questions: 1. The Client will be using MSDE to sync with our SQL Server 2000 DB. The MSDE DB will be on a completely different ...more >>

SQL 2000 Currently, I have push transact replication with immediate updates going out to several subscribers. I want to take the publisher off the network and have a subscriber become the publisher... I will remove replication, and then delete the field "msrepl_tran_version" from all...more >>

I am using merge replication over more than 55 users, (anonymous subscribtion). Today I installed MSDE to a new computer (as before in all 55 computer), run the synchronize (1st time), was working fine. when i try to synchronize 2nd time the following message is coming: Error during mer...more >>

I would like to create a merge replication between few db, but I want to keep the replication even if Publisher would be out of order for some time. How can I co that? I'm thinking about creating one of subscribers a new publisher - is it a good idea ? What would You suggest ? What is most re...more >>

Running SQL 2k & Win 2k Two of my four log readers have the following message.... 'replicated transactions are waiting for next log backup' What does this mean?? Is this a problem I should be concerned about?? Are transactions getting replicated?? If this is a problem, how do I fix i...more >>

What would be a best practice for monitoring Replication? I have Transactional Replication going from the Production database = (SQL00) to the Reporting database (SQL03). Are there some Alerts I need to make sure I have setup to notify me? Should I do a Validate Subscription once a week or s...more >>

I need to import any paradox tables in SQL Server 2000, but i'm having troubles with char conversion: Does anyone have any idea about why all accented chars in source paradox table turn into other chars in the new SQL Table: à in paradox turns into Ó in SQL è " " " " Þ ...more >>

The subscriptions has been marked inactive and must be reinitialized. No Sync subscriptions will need to be dropped and recreated. The step failed. Hi all, i am seeing this message in the Distribution job history, Distribution agent failed. please advise me, how to resolve this issue. T...more >>

Have someone tried to measure what is faster? one publication with 2 tables, or two separate publications each with one table ? Best Regards Wojciech Znaniecki ...more >>

My log reader task keeps failing with the error "the process could not execute 'sp_replcmds' on sql01...". I can execute it just fine in QA on the publication server. Is there anything I can do to get around this? Thanks, Andre ...more >>

I have SQL running on SBS Server A. It is a publisher and a distributor of a database that has 1 subscriber a SQL Server running on SBS Server 2. How does one replicate in a untrusted enviroment. there was also a free ware dll that allowed sql to invoke the ras dialer.. does anyone have the ...more >>