I want to replicate data via Internet using FTP Server, i have SQL 2K with SP3. i set up client network as - Server alias: my local server's nam - Server Name: ip address on interne - Network libraries: TCP/I - Port : 143 But i connect using Enterprise Manage to SQL Server then it errors: A ...more >>

Is it true that using date fields in tables being replicated is not recommended? If true, why? Thanks Emma ...more >>

Hi. I've configured replication between 2 SQL2K (installed on 2 domain controllers of the same domain). My plan was to have the posibility to change data on both sides, changes being replicated even from publisher to subscriber or viceversa. The subscription is a push one. Unfortunatel...more >>

I have tried many times to make a user to run jobs rather than run it using sa, where it gets tough is that the job is a repl-merge job, which needs the proxy account. So I made one, the local admin account who also a SQL Server sys admin. When I run the job using the 'userJob' that I mad...more >>

I am using merge replication with row filtering to limit replication of a table for the past 10 days of data. The problem is that I want the subscribers to automatically remove the data that is older than 10 days after the replication is done (assume that the table has a date field). Question...more >>

Hi, I need to add a new column to a table that is an article in a merge replication. I know how to do that in enterprise manager, but i need to add this new column in the table primary key. I try to do it but it seem that i have to remove the replication, do the changes and then configure ...more >>

I've been deploying/working with replication on a Windows Workgroup. I've created an account with administrative rights. On all my machines I log onto Windows with this account and it is also the account I have designated for replication as the Startup Service Account for SQL Server. Must I ...more >>

Hi I have transaction replication setup and the initial snap shot works fine. However after that updates are giving me the above error. Any help would be appreciated. Thanks Jeff...more >>

I am currently testing queued transactional replication using the Northwind database in SQL 2000. The Publisher and Distributor are on the server "main" and the Subscriber is on the server "backup". Everything is testing fine when I make changes, pull the network plug, restart the subscriber, ...more >>

I am using SQL SERVER log shipping to maintain 7 warm standby databases on a SQL SERVER located at a different location. The network between the 2 facilities has plenty of bandwidth. I am finding that the SQL SERVER agent job created by the maintenance plan to restore the logs on the sec...more >>

Hi, Is it possible to move all replication objects from the old server to a new server without recreating any of them?.. we are in the process of moving existing production SQL server to a new machine (which is the replacement for the old server with the same computer name).. according t...more >>

I have multiple tables with identity column replicated (merge replication) from Server A to Server B. During the initial setup, I specified that sql agent manages the identity columns automatically and runs in continuous mode. But a while, I got identity error and I had to stop the agent, ru...more >>

I'm setting up merge replication between a couple of SQL 2000 servers using DMO and want to use the automatic rather than scheduled option - which EM lets you set when you configure it manually. However, I cant see in DMO what setting I have to make - even when dumping the properties of an EM ...more >>

I have a field in a table that contains date data in the following format: 20040301 what is the best, low impact method for converting this to a useable date field? ...more >>

I've notice that when I disable replication the rowguide column remains on each table. Is there an easy way to remove it? ...more >>

All- Is their a utility that does log shipping? Maybe something in the SQL 2000 Resource Kit? Or do I have to upgrade to the Enterprise Edition from my current Standard? Also, where do I find/install the SQL 2000 Resource Kit? Thanks, DH...more >>

Hi everyone, We are trying to implement merge replication using a central subscriber model. When testing this out on 4 test machines, everything seemed fine. Now, we are running a live test alongside our old system. So far we have the central subscriber up and running and one publisher. The ce...more >>

Hi, we have developed an application using transactional replication, with several publication servers (push) and a distribution server (which is the only subscriber too). It seems to work fine. Now we would "protect" the distribution/subscriber server by using a standby server (note: only th...more >>

Having an anonymous pull subscription over Internet using FTP, the ActiveX control at subscriber give me the following error. The file exists and can be browsed and opened from subscriber location. Thanks for any ideea. Renato The schema script '\\CHRIS900\ReplData\ftp\CHRIS900_Stago_Stago...more >>

I'm using scheduled merge replication with SQL server agent job in mode "Inperosnate SQL server acount". I have problem with Windows synhronize manager, because it don't support this mode, and it always ask for supplaying SQL acount before replication. I need to use Synhronize manager on disco...more >>

Hi, We are having a problem getting replication to work consistantly. The problem is during snapshot replication and is initially at the point of running the snapshot. The error we get is "Attempt to access invalid address. The step failed." We are running Windows 2000 server SP3 and SQL Se...more >>

I'm not a SQL person but need to know if SQL2K can cross- replicate to SQL server machines? In other words, SQLSERVER1 publishes TABLE1 to SQLSERVER2 SQLSERVER2 publishes TABLE1 to SQLSERVER1 If this is a supportable configuration, how does SQL prevent playback of articles that it received...more >>

I used push merge replication over internet. I got the this error log at end of applying both schema and data to the subscriber General network error. Check your network documentation (Source: internet_ip_address\MSDE1 (Data source); Error number: 11 The data were repliacted to subscriber Th...more >>

Hi all, I would like to ask how can i setup a transactional replication without the primary key constraint to be replicated to the destination database or any option that i must choose to make it. thanks in advance ...more >>

Hello, I'm in the process of setting up a new snapshot publication on SQL Server 2000 (SP4). During the process I've created and dropped the publication multiple times, each time setting up the agent to schedule creation of the initial snapshot. During one iteration, I dropped the publi...more >>

(previously posted to another SQL group; no answer so far) We are looking into how to do replication on a SQL Server 2000 db, for disaster recovery. One thing we found was that FK contraints won't replicate well. So we decided to drop the FK constraint, then add it back with a bit of code th...more >>

Running version: Microsoft SQL Server 8.00.760 on Pack Precondition: There are two databases named "M" and "N" on SQL Server "A_pub", and in each of two databases there is a table named "info" but the structure of M..info and N..info are not the same Instance: Creating a transaction publicati...more >>

I am getting a "failed to enumerate filtered articles" but its not the same problem everyone else is getting that the hotfix fixes. I have tried restarting the publisher bit that doesn't fix it either. Both pub & sub are running SQL2000 SP3 with the hotfix. Here is the log from the merge agent i...more >>

Hi Guys, i am using sql 2000 transactional replication to have reporting server. in the oltp server tables i want to keep only one years data (around 1o million) while in the reporting server i will export the archived data and keep all the data so that i can take reportfor any period. wi...more >>

Hi guys, i am new to the log shipping. for logshipping to work we have to create a share off of the directory that the transaction logs are dumped to. can it be on any other server than the source server. 2) what is the meaning of " destination to become an available source destination". p...more >>

The current setup: -2 different non-trusted domains(NARC and HOT). -The connection is VPN and NARC domain has the VPN server. -2 SQL server are installed upon 2 Application Server in each domains(SQL11Server & SQL22Server). -In each domain SQL server/agent starts up with a common local pass-thr...more >>

When Viewing Merge Agents, one of the last columns is "publisher inserts" and I was wondering: Is that number the amount of inserts that took place on the publisher. -or- The number of inserts the publisher made the subscriber do. -or- something totally different ?...more >>

Hi all, I am developing a mobile application for PocketPC. I am using merge replication to sync the SQL CE database with my SQL Server 2000 database. My question is when shoud I use ReinitializeSubscription. I have little knowledge about replication and I would appreciate any help. ...more >>

I was trying to restore over a replicating database. The restore had an error and stopped. So now the DB is in the state of (Loading) and cannot be opened. So I have the problem that I cannot drop it and I cannot turn off the replication. Any ideas?...more >>

I have a table that has a field populated by single character data. in it 'm' is different than 'M'. How do I differentiate this in my queries.... It works automatically on my base SQL server, but not on the replicant. Thanks for the help... ...more >>

my company is starting to evaluate Log shipping as an option for keeping an Axapta SQL instance in sync to a reporting SQL instance. Does anyone know how much extra "Stress" or "Load" would be added to the Axapta database? If the extra workload is too much then this would defeat the purpose of...more >>

Hy I have a hard to trace bug. This is, it occurs sometimes, quit unpredictable. The error happens when we are trying to update data in a table. This is done using an application which is written in Visual Basic. The update is done using ADO, and we are using a disconnected recordset. Update...more >>

Here is some sample code to pull a subscription. My problem is that you can only use structured storage files. How do I use this to pull DTS packages stored within SQL Server? Also how do I specify the DTS package location? BOL Alludes to the fact that it can be stored within SQL Server but giv...more >>