I use Dial up (RAS) Connection for syncronize If I disable my LAN syncronize success but if I enable My LAN syncronize Fail (cannot connecting to subscriber) ...more >>

Hi, I have a Merge replication set up between a SQL Server and many (around 150-200) SQL CE databases. I am using identity as primary keys in 2 of the replicated tables which have a identity seed (set to 1) and range set (set to 1000 with 10000 as publisher range and 80% threshold). All wa...more >>

Hello, I have a merge replication scenario where occasionally the subscription server will go offline for a period of time. It seems that when this is the case the merge agent stops and when the subscription server becomes available I have to manually restart the merge agent for syncroni...more >>

I'm struggling with this error with one of my subscribers. Both the publisher and subscriber have the services running under the same account & password. My subscribers use a dial-up connection. To help troubleshoot, I had the subscriber get connected to the publisher via RAS and had the...more >>

I am running Snapshot replication. I can generate a snapshot successfully. When I try to start the Distributor I get following error "f:\MSSQL\ReplData\unc\FSIREG4SNTSA_CAMPUS7_CAMPUS7_REG4_TO _HR_ORACLEDB\20040614155834\fsipeoplexref_1.sch Transaction sequence number and command ID of last...more >>

I need to add a new column to a replicated table. But in my case a new column should be a part of a primary key. So, I can't use sp_repladdcolumn procedure since we need to completely repopulate the whole table and there is no default value for a new column. In addition to that this column should be...more >>

Hi aLL, I know that we can not update TEXT in Subscriber Database in Queued Updating in Transactional Replication. Is there any way that i can work around. Thanks in advance John....more >>

Hello, Is there a way to add a column to a replicated table without deleting the subscription and recreating it? Thanks, niv...more >>

Hi, I have a database that is replicated between 3 SQL servers at 3 different sites over a WAN link using merge replication. I want to use a trigger on a table to assign a sequential job number to records when one is needed. The trigger recognises certain conditions and determines if ...more >>

Hi, I am writing again because I've now confirmed that merge replication does not work in my case. I'll try to describe my case in a detailed way, as I need to find the solution (fix) for this. I have two servers. One main server A, and one subserver B (there will be more of subservers...more >>

I have a script file which do the replication and in the script there is a lot of table need to be addad as article. So while use osql execute the script there would be cost a lot of time. What I want to do is show a dialog which could show the progress percent and the file name which is now bein...more >>

Hi Guys, i am planning to implement logshipping on sql 2000 EE. i have two questions on this. i am planning to use log shipping interval of 2 minutes 1) can dump the transaction log backup on network share instead of production server. if yes will it have any other impact? 2) every mon...more >>

I am trying to get replication between SQL server 2000 and SQL server 2000 CE going. I followed the steps, pointed out in knowledge base article 304058, but one of the steps seems not to work... I cannot access http://IISServerName/ssce/ssce10.dll through the web browser (IISServerName is the nam...more >>

after deleting a publication from the publisher (which gave a message that it would also delete all subscriptions to it) the subscription remains on the subscriber. There is no reference to it on the publisher anymore. It also looks strange on the subscriber, for example the name format listed in...more >>

I've been trying to set up an anonymous pull subscription for merge replication - SQL 2000 on both sides, post SP3 & same on both machines. However, when I set up the replication and try to do the initial sync, the subscription insists on trying to use the original UNC path where I stored the fi...more >>

"The process could not drop one or more tables because the tables are being used by other publications. (Source: Merge Replication Provider (Agent); Error number: -2147200976)" I get that error when trying a merge replication. I'm using Sql Server 2000 sp3 and replicating to another server wit...more >>

Hi, I was trying to pull a subscription to an MSDE machine(subscriber) from a sql server 2000 machine acting as the publisher and distributor. when I configure for the pull, it generates a snapshot immediately which is successfully completed. But then, the pull actually never happens and I get ...more >>

Hi, I am trying to do a merge replication between machines with sql server 2000(publisher& Distributor) and MSDE(Subscriber). From what I understand, in case of a push subscription process, the merge agent resides on the Publisher and in case of a pull it resides on the subscriber. I want to ha...more >>

Hello: I'm experiencing timeout expired errors on the 'Run Agent' step of my distribution job I'm running transactional replication and I'm able to connect and use both my publisher and subcribing servers (no server connectivity issues). If someone could help me out here, it'll be hi...more >>

Hi, I'm trying to use Transactional Replication with SQL Server 2000 and Push Subsription. Situation: I'm having 2 publishing databases and 1 central subscriber database acting as a report server. I'm adding a first record into the first publishing database, it gets the primary key value...more >>

Hi, I cannot find description in BOL of merge agent profile parameters : "destination threads" and "source threads". How do they affect performance of push replication session. Is "source" a publisher or subscriber? How each of this parametes affects: 1) total time needed to make a series...more >>

Hi. I'm a newbie with sql server, but I have long experiences with databases (db2 and oracle) I have 1 production server and 3 test machines. I would like to transfer tables etc from one machine to another. In this case I just wanna do something REALLY simple.. (so I thought atleast..) I...more >>

Has anyone implemented Transactional Replication for HA. I know SQLServer clustering, in conjunction with Windows clustering is recommended for clustering solution. However I am looking at Transaction Replication between a Publisher and a Subcriber (as in Master-Slave replication) as I feel it w...more >>

Hola, estoy buscando informacion sobre el proceso de replicacion, es un tema nuevo para mi por lo que agradeceria cualquier tipo de información, gracias...more >>

Hi, Can anyone tell me how I can locate what was inserted into the publisher? The merge agent on the publisher says Last Action (Merged 3 data chnages (3 inserts, 0 updates, 0 deletes, 0 resolved conflicts) Further along the merge agent details reveal that it was 3 Publisher inserts. I w...more >>

I've successfully set up replication on two servers, but the third one is giving me problems. Naturally, the first two were development test servers and the last one is the customer's server. It's a Win2000 server, with SP4. The SQL Server version is 8.00.760 (SP3). I upgraded MDAC last nigh...more >>

Hello, Currently I have successfully replicated data between 2 servers. The replication is for the most part stable but does have its "issues" from time to time.I am still in the process of understanding all situations that could cause replication to error out. Anyhow.. Whewww.. I am now...more >>

I have an environment set up between 2 Windows 2000 Advanced Servers where 1 way transactional replication is working fine. However when I do a row update on the subscriber, the queued updating (using sql server queue) then attempts to replicate the change back to the publisher and the following er...more >>

If I decide I don't want to use Queued Updating Subscribers, how do I = get the replication guid's added off the tables in my database? A = restore? I am testing all my options, and have completed testing the use of = queued updating, and want to move on to another option, but the guid's = a...more >>

When I setup my publication, I selected Queued updating. When I setup = my Push, do I also need to select queued updating for the Subscriber as = well? Even though I have no intention of doing any updates on the Subscriber, = I am only doing this because it was suggested as being the best optio...more >>

Hey all, This is one of my first forays into SQL server, so I don't know how dumb this question is. I've got a SQL server db that's going to be the underlying source for an ASP app. Two of the tables will need to be updated somewhat regularly, perhaps 5 or 6 times a month. We actually get the inf...more >>

When setting up Queued Updating Replication it seems to get hung up. It = gets to adding article 445 of 1083 and just stays there for a very long = time. Is there anything I can do or should I just wait it out? I checked sp_who, I don't see any blocking. Any ideas? Thanx!...more >>

although I'm sure not preferable I may be tasked with doing the following and I need to know if it is even possible: scenario: 2 sql 2000 servers each in a different location. One MS Access 2002 database at one of the locations. Can I make the access database participate in sql server replicat...more >>

While setting up transaction replication from 7 to 2000 I generate a push subscription that failed to copy the initial schema over. I deleted the subscription that had caused the problem and started another, that finished okay and is replicating now. However in the Replication Monitor-Publishers...more >>

I have a server that never cleans up expired snapshots from the repldata folders. The Distribution Cleanup agent executes successfully every day. It is successful in removing transactions from the distribution database, but it does not remove any files/folders from \repldata\... No erro...more >>

When I looked into setting this up I received a message that an identity = column would be added to all my tables for this type of replication. Wouldn't this result in my having to change all code that touches these = tables to take the new column into account? Queued Updating is new to me, ...more >>

Hi All, While adding a column in a table which is queued up for Snapshot replication by executing sp_ReplAddColumn, it gives an error "Database Unknown Error". Ne idea why am i getting the error and is there ne work around... alok *** Sent via Devdex http://www.devdex.com *** Don't ...more >>

h how can i add a column to the table at some specified location after publishing the article in transactional replication.is there any procedure or method.please explai thanks&regard reddy...more >>

Hi, We have a website running on a database that is using replication. I have never worked with replication so my knowledge on this is very basic. In the past the website only READ from this database, it never had to do any inserts. Now we have added a registratiopn form that inserts data int...more >>

Does anyone know where I can find Performance Tuning and Optimization information for SQL 7.0 Replication?...more >>

Client utility asks for the Server Alias name, and the server name. If the computer-name is Location1, and the SQL-Server instance name = BOB, and say the ip-adress is 1.2.3.4 Then, Server Alias Name would = Location1\BOB ...more >>

How much maintenance is required for replication? Does the product support manual o automated maintenance? Can the product be configured to support database failover Does the product support replication server failover Does the product support queuing failover TI M Ellis...more >>

Does MSDE support registering a (remote) sql-server. I am trying to replicate between two computers on the Internet (both XP). Is this a futile attempt ... must the publisher be a "full" instance of SQL server? ...more >>

We have a clustered SQL environment with a single backup unit offsite, running over a T1. We are currently seeing a spike of about 300 - 400 MB of data queued every 10 - 15 minutes in Doubletake, though we are unable to track down any procedure that runs in this 15 minute interval. We are i...more >>

Hi. We installed SP3 as described in http://support.microsoft.com/default.aspx?scid=kb;en-us;330022&Product=sql2k And now we have following errors running merge agents: Category:SQLSERVER Source: DB01 Number: 207 Message: Invalid column name 'published_in_tran_pub'. Category:COMMAN...more >>

Is registration of the subscriber required to configure replications. I am configuring replications over the internet using a VPN connection and do not want the Publisher/Distributor (Publisher and Distributor are the same) to have the Subscriber registered. I know you can add a subscriber usin...more >>

Hello, I have a table with an integer as a primary key. I update the row in the first table but the replication fails and returns this error. Cannot update identity column 'ModelID'. (Source: SERVER3 (Data source); Error number: 8102) Thanks, DimSum ...more >>

Hi, I have 3 same dbs on 3 servers that constantly say "loading". I have killed publishing and subscriptions from the 4th machine and the 3 servers dont now subscribe in anyway to this database. I try and detach/delete and I still get the error "Unable to detach/delete whist loading/replica...more >>

This is a srange error because I found the row its looking for at the subscriber.. The row was not found at the Subscriber when applying the replicated command. Any ideas? This one is a big one. niv...more >>

When I set up a pull subscription through the wizard, I get the following error when I try to run the distribution agent -- The subscription to publication '(null)' has expired and does not exist. The step failed <- If I set up a push subscription, everything works fine. Any ideas what would c...more >>

I'm trying to find an SNMP MIB that will let me monitor the replication status of a Microsoft SQL2K database. I know you can send Email alerts from MSSQL, as long as the DB is running under a domain account, but in case that is not an option. Any help would be GREATLY appreciated....more >>

I receive this error, Cannot update identity column How to I resolve this? Any ideas? niv...more >>

i have just setup my main sql server as a central publisher/distributor and a number of laptops (only connect to network once a week) with msde as annonymous pull subscribers, using merge replication. Using windows synchronisation manager i have run the common conflicts i expect to occur and everyth...more >>

I´m configuing a transacional replicationand after concluding it does not function, it is in the status initiating and later it gives the message: " the object invoked has disconnected from its clients" Can you help me?...more >>

Hello, I cant seem to get SQLMail working. We use Exchange 2000 to manage our mail. Any ideas would be great. niv...more >>

How can we achive a SQL server merge replication over the internet when both the client and server are Windows Xp machines and using SQL Server 7? Can someone please explain in a clear step by step fashion?...more >>

I have an application that uses SQL Server merge replication. This application uses a settings.ini file to connect to the server/publisher. This file contains the publisher name, publisher database name, subscriber name, subscriber database name and connection string This application works fine ov...more >>

hi all i installed merge replication successfully,after that i tried to add a row from publisher with id 2004 (it is primary key and autogenerated column)and different other columns,same like that i inserted a row from subscriber with id as 2004 and different other column.when i observed after mer...more >>

Greetings We have been running transactional replication environment in development and QA test. The other evening in a "emergency", development requested several table changes to many of the published tables. I was out of the office and with no laptop available, I tried to blindly guide a cowor...more >>

Is it possible to have a static and dynamic filter in merge replication? I've got a publication that goes out to about 80 subscribers. I'm using HOST_NAME() to filter by subscriber and it works great. As we've moved on, its been decided that we only need the past three months of data at the su...more >>

Hi, We have setup merge replication with 1 publisher and 5 subscribers. 4 of which are filtered. All databases were synched up and everything was great. I then proceeded to update the data at one of the subscribers, by inserting 15000 rows or so. Then when next the subscribers began the...more >>

Dear Friends I have deleted the Publication from the publisher but still the Subscription from the subscriber are not deleted due to same i am getting error while creating new Publication as the table can not be droped as the same are being used by another publication. Kindly suggest h...more >>

I am setting up log shipping according to the "How to Setup Log Shipping" Microsoft White Paper. I want to use log shipping for multiple databases on the same machine and I guess I need to configure each DB separately. My question is do I/should I use separate transaction log backup shares on the ...more >>

Hi All, I've had this problem for about 4 weeks, and I cna't seem to find a solution! I'm trying to create a puch subscription but get the following error when EM tries to create the records: FHQRY: Error 515: Cannot insert the value NULL into column 'step_name', table 'msdb.dbo.sysj...more >>

Hello I have detected a problem with the stored procedure xp_MSADEnabled. I am using Windows 2000 (workstation, 5.00.2195, SP4) and SQLServer 2000 Developer (Product version 8.00.858 SP3). Calling xp_MSADEnabled results in an unspecified error (-2147467259) If I call the same procedure on a Wind...more >>

Hello Experts I am setting up replication on SQL Server 2000 on a Windows 2000 Server machine. The publisher and distributer are on the same machine. The SQLServerAgent service is running under a domain account that is the local administrator on the machine and is also a memeber of the System Admin...more >>

Hello, I have created 3 merge publications on my server. I notice that when I right click and try to view the properties of the publication, SQL takes a long time to pull up the properties of the publication. Any ideas on how to make this 'wait' time less or why this occurs? Thanks, ...more >>