Hi, I'm trying to create a publication for replication. I keep getting this error: Snapshot.exe -- Version Check Error Cannot Run. Incompatible version of resource DLL Resource DLL Name: REPLRES.DLL Resource DLL Version: 7.00.106 Module Name: Snapshot.exe Module Version: 7.00.107 ...more >>

recently i purposely change my email address in my newsreader, and post a question to this newsgroup, not even an hour, i start receiving spam mail with the subject of MS security patch...etc. (worm/virus mail) Is there anyway MS do something on this? anonymous p/s: no doubt putting invalid...more >>

Hi , My distribution agent fails with an error " User error number 515 is invalid. Number must be between 17000 and 2147483647". Hoe can I skip this transection and log it to look at it later Thanks Indu...more >>

Hi, I am really new in this area and hope to get some advice. We have a 17GB database that makes the DB server really busy and the response time is NOT ok for production. We are in the middle of buying a big server however I am not positive it will fix this problem permanently. One of the rea...more >>

Would anyone know why executing an "insert into select" statement in a replicated table is slow? Executing the same statement in a nonreplicated environment is quicker. The amount of data on the tables I am working on are the same. The indexes of the tables in both enviroments are the s...more >>

On occasion we run updates to a very large number of records in a few replicated tables and the Distribution Agent Monitor displays 'Delivering replicated transaction' through most of the replication process of these updates. This only happens when we do the large updates, the rest of the time i...more >>

Hi I had a Transactional Replication setup and running fine till last week. After installing SP3 the replication fails with a vague error message saying "An exception occured in the snapshot subsystem. The step failed." I read in one news group that the publisher and subscriber may not...more >>

Hi all, Quick question.... user has accidentally click reinitialize subscription how do I cancel it!!! I can not allow it to continue, because the user did not click upload data before initialization and I will lose a great deal of data.. and also, it would take about a day to get the new s...more >>

Hi I have configured two sql servers Dev1 and Dev2 for transactional replication. Dev1 (publisher) and subscribes to Dev2. (Immediate Updating) Dev2 (publisher) and subscriber to Dev1. (Immediate Updating) If i insert the data in Dev2 , the error giving while inserting the data as "sa login failed...more >>

We are in the process of setting up an typical environment of sometimes-connected notebook users that will use merge replication with dynamic filters. The actual replication process works fine. I'd like to learn what the "best" way to initiate the actual replication process is, given that the...more >>

Hi, I'm trying to create a transformable SQL server subscription. The goal is to have one publication which is filtered horizontally by the database name of the subscriber. I've created the publication and associated DTS package through the wizards, and modified the transformation script as d...more >>

Hi all, I had diabled the replication and recreate it, it appeared the following error message and did not allow me to create it. Regards, Simon ==================================================== Configure publishing,subscribers,distributor時出現 以&#19979...more >>

hi people!! i've been working with sql server 2000 for about 6 month, and hve being able to create about 32 merge publications/subcription for remote offices without the use of any kind of network connection, how did i mede it work is not important for now,It has worked fine so far. my...more >>

I have two SQL servers on our network. One of the servers has a huge database that we need to move over to the OTHER SQL server on the network. I am doing a simple export/import DTS package. The database does not exist on the destination server so I am doing the DTS as "Copy all objects and data"...more >>

I'm using merge replication (SQL 2k SP3), all PK's are GUID type and I have enforced referential integrity on both sides (Pub and Sub). During one synchronization there was a conflict (INSERT statement conflicted with COLUMN FOREIGN KEY ...) and merge replication caused a deletions of many recor...more >>

Hello people! I would like to know if there'a an internet available how-to about replication in MSSQL Server 2000: I would like to know what it is, how many types, what each one does, how to set up, etc. Any reference would be apreciated. I already have googled, but perhaps not in the right...more >>

I am running sql 7.0 on a active/passive cluster. I am using transactional replication to push from this server to another sql 7.0 server. I keep getting intermittent errors on the distributor agent with error message "General Network Error. Check your network Documentation" When I click on ...more >>

Hi, I have one Publisher and 4 Subcribers, have to drop a column from one of the tables in the Publisher database. Will this change (alter drop <columnname>) propagate to all the subscribers ? Does Transaction Replication support this option in SQL 2000 ? TIA, Pallav ...more >>

I have a problem. I set up transactional replication and the initial snapshot worked great. When I edit data in the published database the changes aren't showing up in the subscribed database. I've looked after changing data directly in a table and by using a query. The Distribution Agent Hi...more >>

hi everybody, i'm trying to delete a publication so i will recreate it again i got this message: sql server enterprise manager could not delete publication "Articles" error 14005.could not drop publication. a subscription exit to it can any one help me please to mange it. ...more >>

On our PROD DB, the owner of the objects are sysdba, not dbo. When I replicate to the backup server (The DB is blank) the owner of the object is dbo instead of replicating the owner as sysdba. When I initially setup replication using the wizards, I made sure to use the sysdba sql login for the rep...more >>

Hi, i have a soft that works using MSDE as db engine. My soft have a server version and a client version, but they use a local copy of the database. One generic client sends once a day all his new records.. and downloads the new records from the server.. (other records may come from the server.....more >>

Is there a way to skip certain commands in the distribution database that are awaiting to be pushed to the subscribers. If we have a huge bcp and want to skip those commands for now and insert something that may have come after that as quickly as possible,can this be done ? Using SQL 2000 and ...more >>

Hi Two-parter question if I may: I have inherited a web-based database application. This application is effectively sold to our customers but hosted on our own machine. Each customer has their own copy of the SQL Server 2000 database. One thing we used to do was real-time replication be...more >>

Hi, All: When snapshot replication is created, bouch of jobs will be created as followings: Name Category 7E32KT8ZLHG7-Northwind-7E32KT8ZLHG7-1 REPL-Distribution 7E32KT8ZLHG7-Northwind-Northwind-1 REPL-S...more >>

Hi, I have been facing troubles replicating a database through internet using the conventional transactional replication method. Troubles occurs when internet is down and I am obliged to reinitialize synchronization. The problem occurs during the initial snapshot transfer which is not success...more >>

I have a merge publication on SQL Server and annoymous subscriptions coming from MSDE instances. When I first build the publciation everything works great and changes are pushed back and forth. At some point, every subscription starts recieving the following error: Error Message: Failed...more >>

Is it possible to add an index to a column of a replicated table? Thanks, Don SQL 2000 ...more >>

We have a requirement to ensure that our web sites are always up and available. We have a pretty basic architecture using 2 webservers accessing a SQL Server backend. This architecuture exists on 2 separate web hosting facilities (located hundreds of miles from each other). We will call the s...more >>

Hi: I have a SQL cluster running transaction replication services to 20 subscriptions. Can I pause the replication on one of those subscriptions by simple click "stop synchronizing". I don't want to kill the replication service but just simply stop it for period of time. I will restart tha...more >>

Hi All I am trying to set up a global subscription by running the store procedures . For that i run sp_addmergesubscription at publisher in the publication databse then i get the following error "The remote server is not defined as a subscription server" What is the reason for th...more >>

Hi, We have a strange problem which we are not able to solve. We use Merge anonymous pull subscription between Sql server 2000(SP3) and MSDE. We have written a trigger in such a way that a field by name 'uploaddate' is set to current date and time when a subscriber synchronises with updated ...more >>

Hi Everybody, Can anybody have any idea on the following error, " The process could not enumerate changes at the 'Publisher'. " The following Microsoft Article contains the above error, http://support.microsoft.com/default.aspx?scid=kb;en- us;Q280684. The above article is relating...more >>

I get the following error message when I create a push publication from AM1 to WS-ROX: Subscriptions were created successfully at the following Subscribers: WS-ROX SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'AM1'. 5 - (Access is denied) Could...more >>

Hi, I am using a transactional replication to replicate a database over a slow link that can have down times ranging from minutes to hours. The distribution Agent has spent 3 days on the action: "Bulk copying data into table 'Archive'" which is the biggest table in the database (around 80Mb)...more >>

Hi there, I configure MS SQL 2000 Server Database replication (Merge) over 2 sites. When I try to start synchronzing, I receive the following error message: The subscription to publication 'ReplicateTest' is invalid. (Source: Merge Replication Provider (Agent); Error number: -2147201...more >>

"If you will have a high volume of transactions, always design your application to use stored procedures to modify data at the Publisher and publish the execution of stored procedures. " -- from the Replication\Planning For Replication\Evaluating the Replication Environment\Planning for Appl...more >>

I have a DB with Timestamps that need to remain the same. I read somewhere that merge replication updates them. Is there any route I can go to basically synchronize 2 dbs? My setup is 2K Advanced, SQL2K Enterprise on one server and Server 2K Pro and SQL2K Standard on the other server. I want the...more >>

We are running SQL 2000 on 18 branches and I want to set up email notification if backup or replication failed where can i found step by step instruction to set it up. Thank you. ...more >>

Hello: On my subscribing server, the initial snapshot failed as disk space was full. This could be seen through the distribution agent. The distribution activity details, indicated that more than half of all the tables were BCP'd over to the subscribing server. After I had made additio...more >>

The Replication Dist. Agent has stopped because an invalid date somehow has been entered into the database . The error being reported is : Datetime field overflow. We've corrected the data but the transaction is still pending. Do I need to drop the publication and redo the snapshot to ...more >>

Hi, We have a distribution server that have all of our transactional replications on it. All the distribution agents and log reader agents keep time out and we have to keep restart the agents. What's the roob cause of this? Too many replications on one distribution box? Or too many ...more >>

I have a database ( SqlSrver 2K ) defined with maxsize unlimited. I noticed the transaction log has grown tremendously; I want to prevent the log from growing further. This database is being replicated to another system. After doing a dump transaction with no_log, when I do a dbcc opentran i...more >>

Hi, We're running a transactional replication of an approximately 10 GB production database using separate machines for the production, distribution, and reporting database. The distribution db data file is approximately 23 GB and appears to be growing 15% per month with the MSrepl_commands...more >>

Hi, I am using Merge Replication to synchronize data between two databases. My requirement is I should be able to filter the rows during synchronization from Database 1 to Database 2 and AS WELL AS from Database 2 to Database1. Dynamic filters will work in one-way synchronization only. ...more >>

I receive this error when I start a push merge replication.. tks for help.. last command {call sp_helpmergealternatepublisher(N'STSNT04', N'dtb_SIM', N'SIM64')} error message The merge process could not retrieve the list of alternate synchronization partners. error details The merge ...more >>

Hello All! having a problems with transactional replication after upgraded to SQL 2000 SP3. not being able to setup new publication and we are keep getting the errors below: SQL SEM could not configure 'distributor_server' as distributor for 'pub_server' Error 0: SqlDumpExceptionHandler: ...more >>

Hello, I have a problem with a duplicate appearing in my last modified table list in SQL. I have been told this is from a trigger misfiring in SQL causing this duplicate record. This in turn is creating major conflicts in the table that shows as duplicated in the lastmodifiedtablelist ...more >>