Hello Group, I had to deactivate my snapshot replication (I deleted it) for a modification on some tables. I was replicating 3 small tables to another machine which serves as an webserver. I set up the replication again, but it does not seem to work. I use a schedule (once an hour) for t...more >>

Hi, We're setting up a mirrored database environment with SQL Server 2005. >From what I have found, we have to perform mirror actions for each database seperately. Is it possible to perform these standard actions, such as failing over the database the other sever, to all the mirrored databases ...more >>

I have schema with transaction replication which has multiple publishers and one subscriber. And I want to minimize traffic. One way which I see is usage of hardware compression on Cisco routers. Are any other ways to reduce network traffic used by transaction replication? May be with usage o...more >>

SQL server 2000 replication - Tran with read only subsriber When i run Validate subscriptions on publication i see error as below : SQL server enterprise manager could not validate subscriptions. Error 20585: Validation failure. Object '(null)' does not exist. Any idea what is wrong ?...more >>

I would like to start the agents every 30 secs as opposed to the current continuos mode for our SQL 2000 transactional replication setup. Time and again, we have our log reader and distib agents timing out and then after 10 attempts they fail and then we have to manually go and start them ...more >>

DearAll, I applied the modifications by implimenting the joins,created indexes on relevent columns which are acting as optimizer hints-result positve improvement in the query processing,apart from that there is one more issue thats supposed to be considered for code reusablity, Eg: When on mor...more >>

We have a few replicated accounts, all have been using SQL 2000. One of the clients the other day decided to upgrade their SQL server without telling us, hence our replication stopped. I tried to get a client connection to their server but was unsuccessful. Is there a client tool or something...more >>

I am replicating 78 tables from a master database for a scale-out solution. My dilemma relates to best design practices – I have found only one article about design considerations for publications and this guy recommended creating multiple publications within a single database publisher. S...more >>

For my learning purposes, I'd like to generate a conflict in MSSQL2K5 Merge replication. How would I make this happen? TIA, ChrisR ...more >>

We have an sql server (server A) at a supplier that is windows 2003, running sql server 2000. Its only connection to the outside world is via normal internet access as any other pc there. Now, at our facility here (which is completely separate from theirs) we have an sql server (Server B) on ...more >>

I have a column in table A with identity value. When i enable Transaction replication on this table and sync the subscriber, it created the column with int datatype Table A on subscriber. I want the Subscriber to retain the identity column so that in case of Publisher failure application ca...more >>

Dear All, I am facing a problem with the following query,taking lot of time to fetch the data, calling the data using multi selects. CREATE proc Rolexi36Sync as DECLARE @date varchar(50),@ydate varchar(50) print CONVERT(char(11),(GETDATE()-1),100) SET @date =3D substring(CONVERT(char(11),(...more >>

Dear All, I have setup a transactional replication between two MS SQL Server 2000. The replication from the publisher to subscriber is success. The replication from subscriber to publisher will retrun 'sa' login failure, so I have used sp_link_publication to fix it, but when I try to ...more >>

Hi everybody, I want to create subscriptions for my visual basic programme. I want to subscribe both the PULL and PUSH subscriptions for my applications from the Server I am able to create the PULL subscription from my application but I could not able to create the PUSH subscriptions. If...more >>

I can replicate most of my tables between two servers, the only problem is on some of the meta data tables where publisher and subscriber both has the same data (including the primary key ) before the replicate, it failed with following error: Replication-Replication Distribution Subsystem: agen...more >>

I've written a custom conflict resolver in the form of a stored procedure and applied it as the resolver for a particular article in my merge replication. This stored procedure is failing because the subscriber is not in sysservers. I use the 4 part name to look at subscriber data like the s...more >>

To summarize my situation: Clients running SQL 2005 Express Edition clients subscribe to a publication on a SQL 2005 Server. Users of the clients are in a group which has a login to the server and as of now (due to needing to test functionality) that group has dbo_owner on the db in question ...more >>

I have been able to reproduce this error twice. In general, the sp_MS* procedures are working fine on all of the other tables that I have tested so far, but for our PointOfSales table, the distribution agent tries to execute the following: {CALL sp_MSdel_PointOfSales (4952)} Transaction ...more >>

On SQL Server 2000, how do you (nicely) get a copy of the Read-Only destination database? The only way I've figured out is to stop SQL Server, copy the MDF & LDF, restart SQL Server, then attach those newly copied files. But isn't there a better way which will leave the original destinatio...more >>

We are using Web Synchronization against a Republisher topology... Meaning we are using load balanced IIS servers against republishers. Right now Each IIS server has a dedicated republisher pointing to a central server, not across a WAN though. Our goal was mainly to create a scalable envir...more >>

Hi there, I'm still fairly new to replication on SQL Server 2000, but, I'm quickly learning (trial by fire). I have a database that has a publication with six subscribers. A couple of the tables have their identity ranges auto-managed (the IDENTITY column in each of the tables is marked N...more >>

Hi, I've been tasked with investigating different methods of achieving database redundancy. In doing so, I'm currently in the process of writing a test application to prove that Database Mirroring in SQL Server 2005 is a suitable solution. Of the established requirements I'm finding dif...more >>

Hi, we are having some trouble with our merge replication between a SQL Server 2005 and a SQL Mobile for Windows Mobile 5. Our replication is a simple one with vertical partition set to true, and column tracking set to true. We have no conflict detection/resolution for logical rows. We have...more >>

Hi, i want to drop Index on publisher and all subscribers, for make new index ! it's possible to run a command for all subscribers in replication ?, instead of one by one command on all subscribers ? thank's ...more >>

hi, i have more tables in more replications. ho w i found the replication where the particular table. exemple. myTable is in R_Film R_Person R_Uk R...... thank's ! ...more >>

I have a Win 2003 Server with Sql 2000. My distribution agent can not connect to the subscriber due to a log on error. I have checked the permissions for the SQL logon user and they are set for system adminstrator on the publisher and subscriber. I changed the linked server user on both serve...more >>

I recently tried to setup a pull subscription from a SQL express to a sql 2005 standard install. I found out that you can not automatically have the sync jobs run because they pulled the SQL Agent from the SQL Express install. Are there any stored procedures that I can call to cause the ...more >>

We are receiving an error when the distribution agent executes the generated stored procedure sp_MSupd_PointOfSales. The bit flag for the identity column is not set and the identity column is Yes (Not For Replication). The sp_MSupd_PointOfSales stored procedure checks to see if the bit flag ...more >>

Hi to all, there is a behaviour in our SQL Server 2005 (w/o SP1) that I don't really understand. In our merge replication, changes can be made at the publisher and on the subscribers. Every now and then the conflict monitor reports that a row insert at one subscriber could not be p...more >>

Hi, I have some tables with huge BLOB(s). These tables have to be replicated among multiple regional servers. I dumped the option of removing BLOBS to file system considering the additional maintenance effort involved (version mgmt, backup, security, transaction etc). Consider the example ...more >>

With every other parameter remaining same, I understand that merge replication performance also depends on conflict resolution detection type. I think row level conflict detection provides better performance then column level conflict detection. Similarly column level conflict detection provide...more >>

Hello I have to synchronize via a GPRS on a Tablet PC and also using the same program on a Pocket PC. I would like to synchronize to SQL server that is to send the data there. The program is using SQL server as back end and front end as VB 6.0. Thx a lot in advance Nazeedah ...more >>

Transaction replication with read only subscriber. Publisher - SQL server 2000 Subscriber - SQL server 2000 entrp Following err noticed in Distribution agent history The process could not execute '{call sp_MSget_subscription_guid(4)}' on 'xxxx'. xxxx - netbios name of publisher What...more >>

hi, how can i know who (job, query,etc...) timeout my replications ? because i don't found the culprit.... can you give me your help or a piece of advice ? Ch. ...more >>

We are using merge replication between SQL 2000 PE and Enterprise and exceeding the 8 query limit in PE. Is there anything in the replication configuration to limit the number of concurrent queries? Thanks!...more >>

I have configured transactional replication with Publisher, distributor and subscriber on different servers. Publisher and Distributor are running on sql 2000 SP4 and the subscriber is running on sql 2005. When I reintialize the subscription, the distribution agent errors out saying "cannot ...more >>

Hi guys! I was wondering if someone could suggest a solution to our problem: We have an in-house production database, containing millions of records, that is being updated using a "drip-feed" approach. We then use replication (transactional, with read-only subscribers) to mirror parts of t...more >>

Hi all, the sys admin has changed the service a/c to another admin. id. But now, i can't start the replication jobs even re-created the publication and subscription with the new admin. id. Any advise? Thanks in advance! 'Executed as user: test.com\admin. A required privilege is not hel...more >>

Hello, I wanted to know how attached table on existing replication, but with no rebuild snapshot ! Because they is very long and very expensive for the server and others processes ! Thank's. Ch. ...more >>

Hello All, I am dealing with a SQL server in which at one point SQL Server Replication is set and its been removed also. At this point, one of the databases still contains "msrepl_tran_version" column in all the tables and the constraints on this column are also existing. Any idea why this ...more >>

I have a business need to implement a custom conflict resolver for a merge replication. I've done this and I want to actually test the procedure to view the output row before I change the resolver of the article in SQL Server 2000 (we don't have a test environment) since this will affect a la...more >>

All, Just wondering if anyone has seen this error before: ----------------------------------------------------------------------------- The Merge Agent failed to upgrade triggers, metadata and stored procedures on the Subscriber to versions compatible with SQL Server 2005. Restart synchro...more >>

Hi, I am just move my SQL server from 2000 to 2005. I have a app under VS.NET 2003 and SQL 2000 server and works fine. Now When I use vs.NET 2003 and SQL 2005 server, I can connect to database, but when I try to using register function and I got following error in teh register page: Ticks mu...more >>

In June I set up a very simple merge replication between SQL2005 Enterprise Ed and SQL2005 Mobile database. The merge replication and identity ranges for the subscripbers worked fine. Now it is July and my boss wants me to write a real application and when I try to subscribe to the publica...more >>

I'm trying to setup transactional replication from a SQL Server 7.0 SP 3a Standard Edition database server to a SQL Server 2000 SP 4 Workgroup Edition database server across the internet. Using the Enterprise Manager on the 2000 server I've established the 2000 server as a distribution server....more >>

Distributor/Publisher and Subscriber: Windows Server 2003 SP1 SQL Server 2000 SP4 Distributor/Publisher and Subscriber created through SQL Server wizardry. Asked for initial Snapshot to be created immediately. It wasn't. Snapshot Agent shows as "Never started". Right-clicking on the Snap...more >>

I'm running dev edition of sql2k5 on a Windows 2003 sp 1 pentium 3 with 512 megs ram. I am trying to evaluate if my company wants to migrate to 2005. In doing so, I am setting up transactional replication with queued updating subscribers. Both the publisher and single subscriber machines ha...more >>

Hey gang, I am trying to add a column to a replicated table and am a bit confused at the syntax that goes into the Column definition. I need to add a datatype which in design view on other tables looks like: DefaultTimeDataType (char) with a length of 8 But according to the "Add Column...more >>

If I truncate a replicated table, will replication freak out in any way? Will the truncate get replicated? I want to delete the primary table and not replicate the changes. Is truncation the best method?...more >>

Hi to all I have a merge replication over a database on sql 2005 How can i keep the log file of the database small in size without messeing my replication? Thanks is Advance Savvas Christodoulou ...more >>