Ive noticed the distributor_admin login created and dont know whats the use of that account . Ive got trans replication setup. Using SQL 2000 ...more >>

I came across some table or stored proc that tells the status of how many commands/trans are still awaiting to be pushed to the subscriber from the distribution db What is it ? Using SQL 2000 ...more >>

I need to be able to script out replication from servers remotely. I would like to be able to script directly to files so I can use osql to run the scripts to recreate replication when I am finished. Requirements: 1. Make create scripts for all publications including all articles and fi...more >>

Hi, I have created 2 scripts using EM, one for creating and one for dropping a merge replication between one publisher and one subscriber. If I run the script for dropping the publication first and afterwards run the script to create the publication again with all subscriptions no erro...more >>

Hi, I'm trying to set up transactional replication between 2 servers running Win2k server, SQL Server 2000 SP 3. I'm using a third server as Distributor, also with Win2k and SQL Server 2000 SP3. Everytime the distributor tries to push the initial snapshot to the subscriber, I get this e...more >>

I have read many references to performing an initial snapshot merge from an alternate location like a CD, but I am hard pressed to locate the procedure for doing so. I cant seem to find a menu command or an option to point the merge agent to an alternate location from which to load the sna...more >>

Hello All - I have a scenario running using W2k and SQL Server 2000 and merge replication. One client has stopped updating. Yet if I attempt to reinitialize or validate / resynchronize, no data is ever transferred to the client. The publisher says status "no data needs to be merged", bu...more >>

any idea why i'm getting this error on replication All old subscription created on SP2 are working properly. We install SP3 to solve problem with overload of CPU (100% - sqlserver continuosly). After installing SP3 I've encoutered next problem trying to create new transactional subscription. Viola...more >>

I am stumped. Can anyone help? I have a Publication database on a Win2KSP1/SQL2KSP1 which is having difficulties syncronizing with a subscription database on Win2K/SQL2K. It was working initially, but hasn't synchronized for the past month. In an effort to fix the problem. I deleted the subsc...more >>

Has anyone managed to replicate a table that has a timestamp as part of its primary key? We are able to replicate (snapshot, merge, transactional) tables with timestamps and are aware of the issues with that. However, it seams that when the timestamp is part of the primary key, non of th...more >>

Does anyone have samples of using MSAccess 2000 as the publisher to a SqlServer 2000 subscriber? The hetergeneouus samples from MS do not address MsAccess specifically. Thanks, Ed...more >>

We have merge replication running. We would like to clean up the data in a table in replication by deleting old data. We would prefer to perform the deletes locally and not have the transactions replicated over the network. Is there a way to run a query on a table " without replication" so...more >>

Currently my work database is 80GB I am in the process of developing a new backup and recovery plan for future database growth of up to 500GB. Has anyone worked with SQL databases of this size? Any info would be great....more >>

We are using Replication with SQL 2000 SP3 on server and MSDE SP3 on clients. The clients are using an Internet connection. The process is working, except when ISPs have blocked port 1433. There's been discussions about changing the port SQL is listening on, but we do not want to go cha...more >>

Hi there, BOL notes that in order for replication agents to run properly, the SQLServerAgent must run as a domain account which has privledges to log into the other machines involved in replication (under "Security Considerations" and elsewhere). This makes sense; however, I was wondering if ...more >>

Hi I have about 8 transactional publications, each of which has one subscriber (I have only one subcscriber, who subscribes to the all 8 pubs). Each subscriber replicates once a day, everyday at the same time. My question is: Can I set the Distribution Clean Up Agent to run once a d...more >>

SQL 2000 SP3. We have a Production and Development servers. I am trying to DTS the data from a Production Publisher db to a Development Publisher db. I get a message "cannot truncate ...." I'm assumming this is because of the tables(articles) contain data. Do I really have to delete...more >>

Hi, Without going into a lengthy discussion, we have a corrupted SQL replication process. We are running SQL Server 2k with sp3. Is there anyway to restore all of the replication objects from backup? Where are these objects stored? Thanks in advance for any help provided. Don...more >>

(reposted) Here's the situation: 1 SQL2K Server on W2K Server (Dist-Publisher) 2 SQL2K Desktop Engines on WXP (Sub1, and Sub2) The DP is set up for FTP anonymous merge. I can create a pull subscription on Sub1, but the operation fails on Sub2 with the error "Name cannot be NULL" when cr...more >>

Having issues doing sql2000 merge replication across vpn links via satellite. merge replication is very eradicate and success rate is very low. any insight would be welcome...more >>

My company database is 80GB backup taking a little over an hour, restore taking little under 4 hrs. I am currently supposed to think about backup and recovery for a 500 GB sql database, can anyone give me some ideas or docuementation on what they would recommend. Is a SAN the only op...more >>

Hello All! after loaded publisher database backup file into test db. we removed replication markers as follow: DB - update sysdatabases set category=0 where name='database_name' or sp_replicationdboption database_name, false Table: update sysobjects set replinfo = 0 where type = 'u' ...more >>

Hello, I want to replicate the CMS database. The CMS dosent support the replication so how i can use log shipping to replicate the database...more >>

Hi all. I have a MSDE DB on a server and want to setup merge replication on some notebooks which are not in the same domain. However SQL Agent runs on the same account on both the server and on each laptop (passthrough authentication). The initial snapshot is in a public share (\\SERVER\Repldat...more >>

Hi, Anyone has script/DTS to generate existing replication scripts (publication, Subscription etc..). I want to script production environment, for recovery or duplicate the production in testing environment. I case production crash, I then know which server,database, tables, sp being r...more >>

Hello, I need to have two databases replicated with each other that allow updates on either database AND allow for the use of text/image fields. From everything I have read, text/image fields cannot be used with updatable replication. Is there any known approach that would work for this si...more >>

Has anyone had any luck implementing this type of setup. We would have replication going from a SQL Server environment to laptops that have an Access database on it. Data would need to flow both ways. How hard is it to setup? Any special tools needed? Any white papers that discuss how...more >>

After setting up replication between production database correctly, everything is run OK (data is replicated from production to warehouse). Suddenly I got the error (Could not find stored procedure spMSdel_XLFeeProfile) when deleting a record from production database (the stored procedure was ex...more >>

Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to he...more >>

Am trying to get a transactional replication to an Oracle database = working but keep recieving the following error "The remote procedure = call failed and did not execute" when I try to apply the intital = snapshot of approx 80,000 records. When I apply a row filter to limit = the number of r...more >>

We are using SQL 2K, SP1a. I have transactional replication setup between two servers. The replication had been working fine. I stopped the distrubution agent as I was restoring the subsciber database from a backup. After the restore, I restarted the distribution agent. I was expecting it to s...more >>

Hi Freinds, SQL 2000 I droped a replication publication. So there is no publication under the publications But I still have the snapshot agent there !!!! Usually when I drop the publication by itself the agent also gone. But this time it is there and when I am trying to delete it , it doesn't ...more >>

I have several large production databases that I'd like to replicate to a reporting and backup server. I'd prefer to use log shipping over replication for a number of reasons. But I don't have the eneterprise version of SQL Server so I don't have built in support for log shipping. I am ...more >>

Hello. I've published two tables and want to subscribe to them using a DTS Package that uses a query to join the two. I've tried a couple of times with no luck. Am I asking for too much? For background, the source tables are, 1) an appointment table without the customer name and, 2) th...more >>

Ok--got a weird situation here... Using SQL-2k on three global sites, all replicating to a single server. WAN connections for the two EU sites and LAN connection to the local site. Ever Tuesday morning, the Log Readers for the EU sites start rolling over ("The process could not execute 'sp_r...more >>

Hi, I am totally new to SQL Server replication, does any one have good references for me to start learning it. Many Thanks, Ken ...more >>

If I have a disconnected device (eg PPC) and have code that saves changes made to the Northwind database. I have updated my inventory to 40 units of the beverage chai instead of just 39,as originally existed on the server from which the data was merge replicated. I have saved this change from 3...more >>

Hi all We're just setting up Replication and understand the differences between the 3 different types of publications. I need a bit of help getting my head around the next stage: We have 2 databases, one is hosted by our Web Hosting company and runs the website - serves pages, stores online...more >>

I have two instances of SQL 2000 Server. One will act as the primary server, the second as a warm standby. I need to use immediate transactional replication for low data latency, and can't use log shipping because they want to use the standby as a reporting server. I can set up the tran...more >>

Hi, I have Merge Relication on SQL 2K. I want to change Stored Procedure on publication database..How it will go to subscriber DB? I don't want to syncronize the snapshot as my Db is very big. Thanks ...more >>

When I click on the Start Agent from Distribution Agents the agent starts temporarily and processes the outstanding requests. When the outstanding requests are finished processing, it stops continuous processing. When I look at the Publication properties it shows the Distribution Agents ...more >>

yes...i have a push subscrtiion.. is it possible to by a command line make a syncronize when i want it, and is it possible to use another user from SA? thanks......more >>

How do I correct the problem when I receive the error 18482 Could not connect to server '%ls' because '%ls' is not defined as a remote server....more >>

Hi, We want to specify a foreign key reference on a column in a table which belongs to a database on a SQL server, to another column of a table on a database running on another SQL server. Could you please give me references to implement the same. Thanks, Vishal Prabhu...more >>

Hi all, It is possible to push/pull/replicate data from an Access database to SQL 2000 database periodically / automatically?...more >>

Hello, Maybe someone could consult me how "two hop" replication could be setup. I mean that there should be two replications - one replicating from database A to database B and second replication replicating from database B to database C. I tried to set-up such environment and failed to do tha...more >>

Hi, How can I change the column name in one of my tables when it is part of a publication on which Merge Replication has been configured and running. I found out as to how to add column using sp_repladdcolumn. But this does not have anything on changing the column name. Thank you in advan...more >>

Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

We are just setting up replication, so please forgive me if this is a stupid question.... I think I understand that if a main site is set up as a publisher, and a remote site subscribes to an updateable publication of the main site, when the remote site updates a rows, the changes get replicat...more >>

I am using SQL Server 2000 transactional replication to replicate data to my one subscriber database. What is the hierarchy of order that should be use to troubleshoot a problem that is not replicating with transaction replication? Thank You, Daniel...more >>