We have transactional replication setup between SQL Server 2000 on Win2003 and MSDE on Win2003 (both SP3a). SQL Server is the publisher and is pushing an updatable subscription (queued updating) to the MSDE instance. We are trying to insert master and detail rows into a pair of tables via a st...more >>

Database A and B are replicated to each other. Both db reside on the same box. The box has been rebuild due to a system crash. All data base files have been preserved. NT SA restored all user databases by attaching the datafiles except master and msdb. Now, the replication system is ou...more >>

Hi We have at the following setup: Windows NT domain 'domainX': Server A running Win2000 with SQL2000 - publisher Server B running WinNT4 with SQL2000 - publisher Windows 2000 Active Directory domain 'domainZ': Server C running Win2000 with SQ2000 - subscriber We have established two-...more >>

Hi, Now, I've installed SQL Server 2000 standard edition, and I've registered the Remote Computer in my Enterprise Manager. How ever when I run the "Create Publication Wizard", I get an Information Message, that: "SQL Server Agent on 'MyComputer' currently uses the system account, which ...more >>

I 've two machines (Linux Servers) with firewall installed at two geographical locations. Now I want to make replication of data using sqlserver2000 from two other machines which are behind the two servers . Both of them have have private IP address and they can access the internet through...more >>

Hello. I am needing to setup replication for some pretty big tables. My distributor has limited space on it. I was wondering if I can redirect the snapshot location folder using the options under properties. Answer is yes, but my question is once the snap shot has been done and mov...more >>

Hi, I need some help in designing the physical architecture of my database system for replication. Here is my scenario I have 1 server each in North America, Europe and Asia. They will be connected 99 % of the time. All the data needs to be replicated between these servers. There is very l...more >>

Hi, I am trying transactional replication between two servers with a remote distributor. I am getting following error each time I run the distribution agent Last Command : {CALL sp_MSupd_Customers (NULL,N'Alfreds Futterkiste - test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'ALFKI',0...more >>

Hi group, we are using W2K and SQL Server 2K with SP2. We have a merge Replication I have the following problem with the Conflict Manager of the Enterprise Manager. I can see that there are 2 Conflicts in the 1. Window. But if i try to to press the press the view boton. Nothing happens. If ...more >>

Hi NG I setup a transact replication (mssql2k sp3a) via TSQL Code from VB6. with the code snipped: SQL = "exec sp_addpublication" ... SQL = SQL & "@logreader_job_name = N'Logreader-" & Me.Server & "-" & Me.DB & "'" It works fine, but the name for the Logreader will ignored. The @logr...more >>

Is there a trick to use mobsync at user level security? We have to set winxp users to power user to allow the subscriptions to show up in sync manager... Anyone know the individual folder/file permissions to set?? Thanks! -- Scott Kramer CDS Technologies, Inc. www.clevelanddata.com www....more >>

Running Win 2k & SQK 2K Someone started an install of MS Project Server and bailed out at some point during the install. Now the server that this was done on, does not have an SQL Server Agent. How do I get the Agent back?? Do I need to uninstall SQL Server, then reinstall?? Is it p...more >>

Hopefully someone could lend me a hand or point me in the right direction. Current System Configuration: Publisher: Windows 2000 Server SP4 & SQL Server 2000 SP3 Subscriber: Windows XP SP1 Due to a system crash, I now have a subscriber table with more rows in it than the publisher table....more >>

Hi, I've got a MS-SQL Server 2000 and I want to replicate my database via the the synchronisation tool of Windows XP (Start-Programms-tool-Synchronisation). I'm able to configurate a new agent for the publication but whenever I try to connect to the sql-server I get the following Error: Th...more >>

Is it possible to have a newly-created table automatically added to the list of published articles? If so, how? ...more >>

I've got a clean install (in the following order) on a brand new Tablet PC: 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build 2600.xpsp2.030422-1633: Service Pack 1) 2) Office XP with SP3 (all components, including Access) 3) MSDE 2000 SP3a (clean install from latest kit) ...more >>

sql2k sp3 I know this itself cant be done. But say Im replicating to a denormalized table via Indexed View. I now want to add a new coulmn to that table and have it end up on both the source and Publisher and the Subscriber. The only way Ive found is to: Add it to both tables. Include ...more >>

On server1 I created a push subscription to server2. I deleted the subscription from server1, but server2 still shows it. I have referred to SQL Server 2000 Books OnLine topics "How to Delete a Push Subscription" and "How to Delete a Pull Subscription", but they are of no help because they on...more >>

How do I keep the transaction log small during initialization of a subscription. The size of the transaction gets to be at least four times the size of the data and fills up the hard drive. Is there a way to initialize the database without keeping the transaction logs? I can't seem to trunc...more >>

Ive implemented merge replication with SQL Server and an Access Database. SQL Server is the publisher and Access database is the subscriber. I have ONE table in the schema that can be updated in both the subscriber side as well as the publisher side. I have an IDENTITY column in this table and...more >>

Hi Friends, I have setup log shipping from my Primary SQL 2000 Enterprise server to Secondary SQL 2000 Enterprise server. SQL Agent service keep stopping after every 4-5 minutes. I could not figure out...why? Also when I try to enable out-of sync alert, a red cross appears on log shipping pair. ...more >>

Hello, We plan to use SQL Server 2000 and to have one central db and multiple distributed db's. Scenario:- - Reference data is controlled centrally (central > distributed db's) and end-user data will travel in the opposite direction (i.e to central db) - we have extremely flakey comms! ...more >>

Hi Guys , just a quick question, my client has merge replication and they need to remove replication so they can make some schema changes add tables etc, they will then reset this up, if you remove replication do the uniqueidentifier columns it adds get removed? or do they remain behind (sql 200...more >>

I have a database that is merge replicated across 5 sites Some how the database isnt in sync, although testing the syncs works fine I assume when I modify a record in DB A that it issues an insert or update when the merge rep runs depednant on whether the records with the same GUID exists ...more >>

Hi! When i create a Transactional Replication between two SQL Server 2000 (with no additional Service Pack or Update) with the Enterprise Manager, i get this error (also when i restart the agent): Invalid cursor state (Source: ODBC Driver Manager [ODBC]; Error number: 24000) I think it the M...more >>

Hi We have been running Merge Replication for quiet some time. After doing some house work of clean up redundant 'remote servers' and cleaning up client subscriptions that are no longer used we are getting the following messages. At the client end: The merge process could not update ...more >>

Hi chaps, SQL2K sp3 I have set up a custom subscription process for our environment where we have very crappy RAS lines to our subscribers (lots of Tablet PC's). Instead of applying the snapshot from the publisher, I zip up the last snapshot - copy it down to the subscriber (using copy with ...more >>

When merge replicating SQL Server tables with created Statistics, the SSCE subscription to that table fails. To avoid this problem I manually deleted the lines with CREATE STATISTICS statements from the *.dri archives that contains the script for index creation on the snapshot. The *.dri archives...more >>

I work for a company one of whose clients is experiencing problems with performance of SQL 2000 replication over a wan. We need to bring in a consultant to both reproduce the problem in-house, and also to solve the problem for our clients. Please let me know if there are any consultancies th...more >>

When using named subscriptions, can a group be added to the list of replication partners, or does each subscrber need to be added individually? ...more >>

Morning Guys, I really need you help, I am just about to seriously pull my hair out. Here is the situation. I have 1 server running SQL Server 2000 sp3a with merge replication setup, and 150 users on laptops running MSDE 2000 with the latest service pack and dialling up to the server via a ...more >>

Am I correct to assume that the Host_Name function, when used in a filter expression at the publisher will return the subsriber host name? What does SUSER_SNAME return: The name of the current logged on user at the subscriber? The name of the SQL server run account ath the subsciber? Or...more >>

I have setup replication from one SQL 2000 server to another. All I am replicating is one single small DB. The replication of the data seems to work fine. however, permissions (both on public and a special user) are not replicated. I have been unable to find how/where to specify repl...more >>

Hello, We have problems with a SQL replication between 2 SQL Servers, some days it works fine, but some times the replication is not succeed and there are lots of missing records. We do not know how to determinate what is causing these problems, and we would like to know if there is a tool ...more >>

I setup transactional replication with automatic updates. In doing this I did a manual initialization of the schema by doing a dump and restore of the publisher. When i validate my subscription i have many tables that dont pass the rowcount. I think it may be that between my restore and i...more >>

We have a database application that is currently being replicated to 2 remote sites. In the near future, I expect that this will increase to many more sites. My question is this, as we move forward it is probable that at some time we will run into the need to replace the server that currently ...more >>

I have an application that uses SQL Server 2000 as the back end server and MSDE on subscribing databases on laptop computers which replciate over GPRS during the day. The database version is SP3. Data is filter to the subscribing databases based on Host Name representing the device allocated ...more >>

I want to dynamically filter my published data to many subscribers based on a number contained within the server name of the subscriber. ie one subscriber server is called 8364-Server and I want to use the 8364 as the "club code" to extract the subset from the publisher. I preferably want to use...more >>

Hi Guys, Is there a way to specify the accounts under which the MSSQL and Agent services will run during installation? I did not see an option in the switch commands in the setup.exe. Also, changing those accounts without EM seems to be pretty involved. Is there any other way to c...more >>