We are investigating a software enhancement requests and need to know if a database is replicated to a different Server and the password is changed for a user on database A that is also a user on database B will that password "replicate" over to database B or does it need to be changed on that...more >>

I have a dual xeon machine with 4 gb of ram . I have several publication I am wanting to replicate. Figured I would install 2003 server standard edition with sql2000 ent. edition. Any suggestions on setting up the sql part? I shouldn't really need to setup any vsql servers or any of ...more >>

Hi All, We know that, "NOT FOR REPLICATION" option makes it possible for replication agents ,let's say, to insert rows without being constrained by IDENTITY restriction or check constraints. That means, being a replication agent is like having a PASS CARD that allows them to get rid of constr...more >>

I am having what appears to be a very common problem. I still have not found the solution, though hints can be found all over. Could someone please illustrate how to allow transaction or snapshot replication when receiving errors about foreign key constraints? I am not sure of the actual ste...more >>

Hi all, I should program a small VisualBasic program for monitoring the status of the subscription. It is a Pull anonymous subscription to a Snapshot publication. It is supposed to run at the subscriber, a laptop PC, and provide info to an human about: -Wheter the distributor is reachable/ava...more >>

Hi, In COM conflict resolver, let's say, subscriber tries to upload an INSERTED row to the publisher. By setting rct = REPOLEAllChanges in the IVBCustomResolver_GetHandledStates COM function I can catch all the changes not only conflicts. And in IVBCustomResolver_Reconcile function of the...more >>

Here's the setup. 3 database servers. One in Chicago on Central Time, 2 in the UK on GMT. Trying to log ship database to secondary server in UK and using the other server as a monitor server. 2 different domains, but trusts are configured properly. Permissions granted to SQL Server prop...more >>

just putting out a feeler on this since I think I am about to be asked to do this. Can I add/remove indexes on replicated tables? If so, will that schema change replicate to subscribers (sql server 2000 subscribers)? I have used the sp_repladdcolumn stored procedure. Hopefully there is one ...more >>

Hello group, I need to set up replication between 2 sites today. I have successfully implemented transactional and snapshot replication within the same office servers before. I need help configuring 2 servers that are in 2 different cities and not on the same network. First of all, is this po...more >>

I am developing a distributed database system that uses a locking mechanism to control data changes. Each site needs to aquire a specific lock before it can change data. After changing the data, the site releases the lock. The data and the lock are replicated to other sites of the ditributed s...more >>

Is it possible to replicate a SQL database (in DMZ) to an Access database located inside the firewall? From the SQL server, I cannot map drive to computers inside firewall. Thanks in advance for the help. ...more >>

Hi, I am new to replication, I have the following tables in my database, and I would like to replicate to other subscriber using Merge Replication: tblProduct (Product master) ---------- ProdID (PK) ProdGrp (FK to Product grouping) ProdDesc tblProdGrp (Product grouping) ---------...more >>

Hi, I am in the process of setting up log shipping for a large database ~ = 1GB over VPN and slow WAN link.=20 I intend to setup and sync the servers on main office and ship after = that, the warm standby db to remote site. My question is how the daily full backups of database will afect ...more >>

Greetings, I have developed custom replication software that I have been running in house for 2 years now. During replication operations I have been SETting IDENT_INSERT OFF and then back ON again (after replication completes). I have also been disabling and re-enabling my CONSTRAINTS. I h...more >>

Win 2k & SQL 2k What table is the pending transactions stored in?? Can I delete from this table without causing major problems, other than of course, loosing the tranactions I am deleteing? Larry......more >>

Is it possible with SQL Server 2000 to implement a replication offline between 2 sites which would be connected sometimes using a modem. I wonder how the replication can be done. Thanks for advice...more >>

Hi, I am setting up a new queued update - transactional replication using sql as queued commands store. There is no problem about publisher to subscriber distribution. But queue reader agent that will deliver transactions from subscriber to publisher fails with an error message saying "ODBC ...more >>

hi i am working with mergereplication pushsubscription between a local server and remote server.the link1024 kbps link.last week suddenly link gone for 15 minutes.after the link is active the agent tried 10 times to reconnect to the subscriber and failed.later manually i gave start synchron...more >>

The distribution agent of a replication between 2 servers is stops with the message : 'The process is running and is waiting for a response from one of the backend connections' When i search more precisions i find : Timeout expired (Source: ServeurSQL (ODBC); Error number: S1T00)' When i resta...more >>

I read in a previous post (comments by Hilary) about monitoring agents closely to avoid reintialisations. I'm sure we would all like to avoiding reinitialisations - some tips/reading on how to effectively monitor the agents - what to do/look for etc - would be a great help. Thanks Darren ...more >>

Hello, I'm using merge replication with SQL Server 2000 on Windows 2003 server, with MSDE2000A clients with anon pull subscriptions. Some data has been (mysteriously) deleted and I would like to find out more about who/when it was deleted. Is there any way (system tables, transaction log ?) of ...more >>

I want to decide between merge and transactional replication. I am unable to do so considering the following buisness scenario I have a SQL 2k publisher with 3 MSDE's as subscribers. The data can be updated from anywhere. There is a table called as customerprofile(CP) and there is another t...more >>

Hello, I did the replication like it is quoted in my .NET CF Programming with C# - Book and on this <a href=http://msdn.microsoft.com/SQL/SQLCE/default.aspx?pull=/msdnmag/issues/03/09/datapoints/default.aspx> ReplicationExample</a> site, because i want to go through the sample of this s...more >>

sql2k sp3 Howdy all. Ive been trying to avoid using Indexed Views for Replication in my scenario because Im not totally faliliar with the whole schemabinding deal. Plus I like the convenience of sp_repladdcolumn. I was going to use Custom Sync Objects instead but I think they may not work...more >>

Hi, I want to install a Merge-replication on a simple View. This is a simple View named "urm_Con": SELECT * FROM CON WHERE CON_SA='ARTG' While creating the publication I have selected this view only, table "CON" and view "urm_view" are installed on server and on client. The snapshot work...more >>

Hi I'm trying to workout how to replicate AD, Exchange and SQL Server between a headquarters and remote sites where there exists either a very poor or non-existant WAN link. There would be one domain across all sites and W2003 and latest version of all products available to be used. My cur...more >>

Attempting to drop a column of type 'text' exec sp_repldropcolumn @source_object = 'OrgCobrandRes', @column = 'CobrandText_temp' GO Getting the following error: Server: Msg 5074, Level 16, State 1, Line 1 The object 'DF__OrgCobran__Cobra__064EAD61' is dependent on column 'C...more >>

Is it possible to have replication to SQL 2000 servers that are network separated, where they cannot see each other, but they can both see workstations in between? Can you use an interim server for the snapshot location, and have the servers replicate even though they cannot directly see o...more >>

Hi, In my publisher database I have defined an user with restricted privileges. This user is "used" by the user interface application to connect to the database. How can I replicate this user and restrictions to the subscriber? Should I script this on a post-snapshot script? Is any other autom...more >>

Right now we have 7 different subscribers for 7 different databases. They are all currently distributed through 1 distribution (default) database on the distributor. I have read threads in here regarding this being a single point of failure. Does anyone have a link or guide that descr...more >>

Sorry if this is the wrong place to ask this. I have a file "restored.mdf", that was simply copied from the disk by backup software, i need the data inside that file. It is 12GB. the file was backed up from E:\SQLData\MSSQL\Data\ABC.mdf, and is now in E:\SQLData\MSSQL\Data\restore\restored.md...more >>

Hi, I have setup snapshot pull replication between SQL2000 (publisher) and MSDE2000 (subscriber). The following error "Invalid Descriptor Index" is occuring on the subscriber. Would someone please tell me what this error means and how to get around it? Thanks ...more >>

We were using transactional replication when for some unknown reason it stopped. We tried to get it going again without success and decided to remove it. There are no longer any publications or subscriptions and the distribution database no longer exists. However, there are still some r...more >>

hi all, i forget to check the enforcerelationship for replication in the design mode of a table in the process of merge replication. i remembered that after generating the snapshot and establishing connection with the subscriber.is it possible now to check that option.is there any problems...more >>

Who can tell me where to find the fix? http://support.microsoft.com/default.aspx?scid=kb;en- us;814916...more >>

Hi, I am trying to implement central subscriber topology. In the document about replication (http://msdn.microsoft.com/library/default.asp? url=/library/en-us/replsql/replplan_9cfm.asp), it says, "The destination table is partitioned horizontally and contains a location-specific column ...more >>

Hi We have a database that gets new contents once a day at a certain time. This DB is being replicated (Transactional) to 5 subscribers that are serving web servers. Anytime that new contents are being replicated to Subscribers we experience massive blocking at the subscribers. We have b...more >>

Hello I'm asking this without having answer: I followed these instructions to set up replication: http://support.microsoft.com/default.aspx?scid=kb;en-us;321176&Product=sql2k#3 From what I read in the help and everywhere this is soppoused to set the PublisherB as the alternate synch parter. ...more >>

I am attempting to configure log shipping between 2 domains. The permissions are supposed to be set up correctly. However, when I attempt to create the maintenance plan I am unable to specify the share on the secondary server where the transaction log backups will be sent to. The seconda...more >>

Question about SQL Replication in a SQL 2000 Federated Databases environment: We're running Win2K3 on our production servers, SQL 2000 w/SP3a, we're currently looking to expand our database operations and looking into Federated Databases. We currently have replication going on between tw...more >>

sql2k sp3 Im going to start Replicating 40 or so tables. Is there any good/ bad to each table going into its own Publication? TIA, ChrisR...more >>

Trying to run ALTER TABLE ... get the error message: Server: Msg 4929, Level 16, State 1, Line 1 Cannot alter the table 'blah' because it is being published for replication. Now, I read somewhere that there is something you can do in SQL Server 2000 to make changes to published tables withou...more >>

Can the Simple Log Shipper included in the SQL 2000 Resource Kit be used = with SQL 7? Mike...more >>

I am receiving an error on a log reader: The process could not execute 'sp_repldone/sp_replcounters' on 'ROUSE18SERVER'. The full message is: Operating system error 998(Invalid access to memory location.) on device 'd:\SQLData\MSSQL\data\TimeClock_Log.LDF' during I changed the log rea...more >>

Hi, I am new to replication, I am confusing with row filter and join filter. If I only use row filter, does the SQL server replication caused any data integrity problem? e.g. simple relationship of such table tblCustomer, tblOrder and tblOrderDetail? Thank you. HKM...more >>

I want to send an e-mail to an operator after the replication has ended with the results (errors o success). The problem is that MS documentation starts saying "Click on the Control Panel Mail Icon to start ..." the problem is that this icon does not exists any more in W2000 server. So what to do...more >>

hi all, i established merge replication between two servers with no synch option.i dont have any idea of how to restore it original is it fails.how can i restore both publisher and subscriber with out any data loss.what is the recovery plan i have to use. your help is appreciated thanks ...more >>

We have Database A. Database A Training Database B "Database A Training" was a copy of "Database A" 6 months ago. Since then "Database A Training" has had replications set up to "Database B". Last night a collegue decided that "Database A Training" needed updating and so backed up "Dat...more >>

Hi all, I set up a transaction push subscription and all was working well until the distribution agent ran after the snapshot. I started to get the error message pertaining to the table employee and others: Procedure or function sp_MSupd_employee has too many arguments specified. (Source: ...more >>

I am doing trans replication between two servers with a pull subscription. Both are on the same domain and just the straight defaults are selected, no added configuration, the database is even created new in the sql box. The snapshot says it ran completely, but I get an error on the subscripti...more >>

Subscriber is a local db on laptop which is supposed to connect to SQL Server periodically to synchronize data. I was able to do all steps necessary - published the database and create a pull subscription. When I try to open local database (on laptop) it first has to synchronize data. I'm g...more >>

I have a very large table (10 million + rows) that is being published in a transactional replication. I need to change the current primary key on the publisher to a non-unique index and add a new primary key. I really need to find a way to do this without having to recreate the subscription as...more >>

I believe I have read this before, and apologize for being redundant.... If you have a new server that will be dedicated to reporting, it is more = efficient & faster to make this server the Distributor & do a PULL from = the production database? I am pretty sure I have a pretty good underst...more >>

I would like to do a backup of a publishing database and restore as opposed to syncing from scratch that might take a long time for a huge database. In order to do so, I would like to freeze changes made at the publisher somehow... backup the database after its frozen, restore the database estab...more >>

Replication is failing with an error message about inserting a duplicate = record into a reprint table, what can I do when a duplicate record error = is present?...more >>

I created a snapshot merge publication at the publisher and pulled it at a subscriber. The snapshot failed (due to a relationship 'loop' between filtered tables) near the end of downloading. I deleted the subscription, and disabled publishing at the publisher. Corrected the relationship pr...more >>

Hi, I have a anonymus pull transactional replication over Internet with FTP for snapshot. My question is: What type does Sql-Server (suscriptor) uses like FTP client to connect with FTP Server and get snapshot. Active o passive? Table for Microsoft Clients FTP: Command Line: --...more >>

I have several workstations that are running a custom app using MSDE2000. I need the PCs to replicate with a SQL server via modem to pick up subscription and exchange data. What is the best way to accomplish this? Currently I am using MOBSYNC and scheduleing the event. It has been unreliab...more >>