Hi All, Sorry for a long post but I'm not very good in english and so cannot describe my problem in any other way. Please bear with me. I'm trying to implement a solution that requires data synchronization across multiple locations. My application will be running on various branches of a ...more >>

Ok, suppose I have a dotnet application that uses MS SQL server. The SQL server is maxed out. Suppose the code is already optimized and suppose I've already maxed out the ram and processing power. What ways are there to load balance it so that I can scale the application further up? ...more >>

Hello. Anyones knows why sql show me this mesagge ? "Could not allocate space for object "sumkardex" in database "Ventas" because the primary filegroup is full" ? Thanks !!! ...more >>

Hi I have a problem with merge replication involving the merging of related records at different times. I have one publisher and two pull subscriptions (three locations). The Merge agents have a "high volume profile" and run every 15 mins over a 2meg VPN Currently I am getting instance...more >>

Hi There, I want to do the following. Please guide. Q1. I want to change the datatype on the publisher database. How can I do this? Q2. Once the above step is through. I want the effect to be taken on my 6 subscribers. What is the best way of achieving this? Thanks Vivek ...more >>

Hi, We have a problem that we can't find a solution to ... yet ... I hope someone can help us out. I will try to discribe the problem below. 1. We publish a publication with articles to the subscriber(s) in immediate replication mode. 2. The we make an insert at the subscriber side. 3....more >>

Hi all, Setup: SQL2K (Enterprise) [SQLSVR1] in Network 1 - 2 publications (merge for tables that data changes in often, and snapshot for stuff that is batched after a few months) - there are a number of MSDE subscribers to these publications in this network. The same setup is in Netw...more >>

Hello, Could someone explain me what it meens. I have made 2 merge publications with dynamic filters: suser_sname() The first one does not validate subcriber before the synchronisation The second one validate with 'suser_sname()' I do not see differences between the 2 replication, and i do ...more >>

Hello there I have two databases on far place In some hour of the day i replatate them But if i add line on the publisher with primary key and on the subscriber i add also another line with the same primary key on the subscriber there will be two lines with the same primary key What i ...more >>

Hello, I am trying to replicate over FTP (merge replication) and I'm having trouble with subscribing. After 60-70 minutes I get a timeout error and the initial snapshot fails to work. The exact error is: "Category:OS Source: Number: 12002 Message: The operation timed out"...more >>

Hello there I've created my own replication I would like to so some action that will cause the replication to be done Is there an action that do this or by enterprise manager or by some store prosedure? ...more >>

sql2k sp3 Is there a way to turn off the Dist Agent ONLY once the pending transactions are committed? A way to gaurantee that nothing will be missed? Im using Custom Sync Objects and my Insert/ Update Procs arent automatically Updated. I have to update them manually. If I update them whil...more >>

Hi, I have a transactional replication setup between two SQL Servers. Only some of the tables are required to be replicated. The problem is now that on the publisher which is linked to MS Access, the tables that are not replicated cannot be updated for some reason. However I can update thes...more >>

Hello everyone, I need some pointers to do the following: 1. I set up a publisher 2. I Set up a distributer --To have anonymous merge replication. 3. An installer installs MSDE on the client computer if it doesnt exist. I want to run something on a client computer thats not ...more >>

I have read & read & read and cannot seem to find the answer to my = issue. I have several publications on SQL-01 with Transactional Replication = from one db to another, running well. Now I have a new reporting Sql Server - SQL-02.=20 I set the Distributor up, and created the reporting db ...more >>

Hi, We've been using logshipping successfully for over a year, but recently we are experiencing more and more failures relating to the Transaction Log Backup Job. We are currently log shipping 30 databases from a W2K(SP4) SQL2000(SP3) server to a W2K3 Server (SQL2000SP3). The backup jobs ...more >>

Running SQL 2k & Win 2k Is there a way of moving the distribution db from one drive to another? Can I use the same SPs that are used to move any othere dB?? TIA, Larry.....more >>

Dear All, I recently set up a DB for replication testing. My testing is complete so I deleted the 'Publisher' stuff in the test database, and managed to delete the subscriber. I then went to delete the publisher db and got the following error message Error 3724: Cannot drop the database ...more >>

I should first state that I am not a DBA, I write system software usually. This is a conceptual question more than a technical question. I have an application that I run on two different networks. It is the identical application with identical database. The problem is that the two cannot e...more >>

I have setup a merge replication and run it for long time. However I would like to add additional table for replication. What steps shuld be done in order to achieve the goal? ...more >>

I have 35 small (<2 GB) OLTP databases containing about 80 tables. We have a need to mine this data and do not want to do this on the OLTP servers and would prefer creating a seperate large merged database on a different system. There are no columns in the table that indicate which database the...more >>

Hello everyone, I'm new in replication, I have some - maybe trivial - question. First of all, I'm using a MSSQL server as a publisher, the clients are Pocket PC's, running SQLCE. All clients need only a subset of data, which can be controlled via row filters, using SUSER_SNAME(). For the f...more >>

Hi, I would like to programmatically setup replication on the remote subscribers. I saw the sqlMergeXLib interface, but it did not go beyond setting up a subscription and automatically synchronizing it. I would like to set up the subscription properties and also monitor them through code. For...more >>

Hi I have an MSDE database replicated from a remote SQL 2000 server. I also have a SQL CE database which I need to keep up-to-date with the MSDE database WITHOUT using replication (cannot install IIS, etc on client PCs). Tracking changes on SQL CE is easy enough, as are user changes on the M...more >>

Hello, I am replicating databases from a sql2000 server with a seperate distributer running sql2000 server and a MSDE subscriber. I am using merge replication. The subscribers pull a subscription. We want to have this setup across the internet for multiple subscribers each o...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(And also it does not change SEED value in the table). That means, being a replication agent is like h...more >>

Hi, We are setting up a replication between two SQL 2000 servers in Transactional Replication mode, Updatable and immediate. All is fine until you try to insert a record at the subscriber. If you set the Identity column to "Yes (Not For Replication)" as recommended you get the error message "Se...more >>

I am trying to register a sql cluster (SQLVS01) on a server that is on the other end of an IPSec tunnel. The goal is secure transaction replication of seperate publications in both directions. I am not having any trouble registering the remote sql server (SQL03) at the cluster location but whe...more >>

Hello. I'm running SQL Server 2000 (sp3a) and am moving the installation to a new machine one database at a time (by using Backup/Restore). The new machine and SQL installation also has a new name that is being kept. The databases that I've moved thus far are not replicated databases so it...more >>

Hi all, Sorry to post this one again but I have added some more info..... I have a sql2000 SP3 merge replication set up using dynamic filters to 29 sites/publications so each site only see's it's own data. I have been adding new tables to the schema using sp_mergearticle (but that is an...more >>

Hi, I am facing the following problem. Please help me to solve it. ---------- My question is: How to force the replication engine to include not only the updated records but the relevant records as well? ---------- I am using merge replication (SQL2kSP3 with SQL2kCE) with row filtering. ...more >>

Hello!!! =20 I need to change the data type of a column in the replication. How can I do that? Thanks...more >>

I am trying to make sure the new replicate distribution server is the best it can be. Below are some tips I read on a site. It seems like the first two tips almost conflict with each other. however, they could be talking about maybe a log reader agent on the first one. Most of the pu...more >>

sql2k sp3 Before I start I like to thank Hilary and Paul. You guys have been a huge help throughout my ordeal. Ive decided to go with Custom Sync Objects because of my recent discovery about the headache it is to add a column to a replicated table that was done with an Indexed View. I thi...more >>

Does transactional replication work in an environment where there is no domain contoller. Trying to replicate database between two servers?...more >>

Hi, I have setup unidirectional transaction replication between two SQL2k servers. On the subscription database I have set the PK as (Indentity not for Replication). I can insert and delete records on the publisher and they get replicated without any errors, but on the updates I get an erro...more >>

Hi, I would like to send some scripts to be executed at the subscribers; but i want to specify ftp locations, not UNC locations (since I am using FTP subscribers). Does somebody knows how to do that? Thanks, José. ...more >>

Hi all, I have a sql2000 SP3 merge replication set up using dynamic filters to 29 sites/publications so each site only see's it's own data. I have been adding new tables to the schema using sp_mergearticle (but that is another story !!). I have been running the sp_mergearticle , running the s...more >>

I use SQLServer2K to manage a sortation system. I have one server that acts as the primary server and a backup server that subscribes to the publication on the primary. Lately, my distribution agent has been failing with the following comment as the Last Action: "The row was not found at ...more >>

If I have 100 tables that are not first level dependencies with articles that are not participating in replication, but may contain some dependencies amongst themselves, will snapshot replication work on these articles or will I run into foreign key problems? -- Bryan Bitzer MCP Senior Data...more >>

Dear All We are running SQL 2000 Standard sp 3a on two Servers both 2003 machines. One server is our Production Server (publisher), the other a Warm Standby (subscriber). According to BOL (http://msdn.microsoft.com/library/default.asp? url=/library/en-us/replsql/reploptions_8zjn.asp) t...more >>

Hello, Can anyone tell me whether having your log file back up affects the Log Shipping in any way ? Jim...more >>

I have try to perform replication to an access database through 56K dialup. However it shows the following message: The agent is suspect. No response within last 10 minutes It seems the agent is timeout. But when I view the status of the agent it still under synchronizing. Why such things w...more >>

i need to know how to setup replication between two sql servers - can someone reply with the basic steps, Thanks...more >>

Hello, I have a VB.NET service that has a timer. On certain timer ticks, a merge replication is called. I have a wrapper class that asynchronously starts the merge replication process (using the .BeginInvoke() method). I did this so that my service could continue to do other things w...more >>

Greetings, Some of our users want to manually start and stop distribution agent(Replication Monitor-->Agents-->Distribution aegnts--> right click on publications and Start). So obviously i have installed EM on users machine. the issue is they can do this task only if they have "Sys Admin" pri...more >>

I took a backup from a merge replicated database and restored it to a non-replicated db. I want to make changes to the db but the system still thinks the db is replicated, and I can't seem to get rid of any articles or publications. How can I undo the various replication flags and whatever...more >>

My distribution agent failed. The error msg: "Could not find stored procedure 'sp_MSupd_Sessions'." But I could not find this stored sp_MSupd_Sessions any where around the world! Can't find from google, can't find from Microsoft ......more >>

Hi! i have big problem, i had to remove my merge replication (between Sql2000 MSDE, one way replication only from Publisher to Subsciber). After recreating this replication, merge agent do not wan't to merge any data, i'm obtaining NO DATA NEED TO BE MERGED. i can update all values (by SQL ...more >>

sql2k sp3 Howdy all. I know I cant use sp_repladdcolumn to add a column on an Indexed View thats being used for an article. But it seems to me that I should be able to add the column to both the Pub and Sub tables, alter the Indexed View on the Pub, and alter the Insert and Update procs o...more >>

Hi All, I need urgent help on a merge replication issue.I am replicating to 2 subscribers. Updates/Inserts to all subscriptions works fine from the publisher. ( all articles) From one subscriber through the whole system also fine. But on the 2nd subscriber I can replicate most articl...more >>

A colleague of mine ran a script using sp_addscriptexec against a merge publication and did not .... or does not remember if he included the @scripterror parameter. The script will not run and the agents (about 15 of them) will not now run and replicate the changes accross this worldwide m...more >>