Hi All I am trying for a multilevel Replication using merge replication . Can you please tell me the way of make a "global subscription" and "Republish" the same databse Thanks PrasanthB...more >>

Hello all, I have encountered an error where sp_MSgetserver returns no data. This I think is causing an error when the replication agent tries to determine the licensing setup and thus the replication agent fails. The Log File for the verbose repl agent output is XXXX.: {call sp_MSge...more >>

I had a problem with replication configuration, so that, I deleted all configuration. When I try to configure again the replicaction I got next error Error 21007 Cannot add the remote Distributor. Make sure that the local server is configured as a Publisher at the Distributor. I ran th...more >>

Biggest Problem (Very imp scenario for all of u, u must aware of this....problem in sql server 2000) Here I have a different scenario in Merge Replication using SQL SERVER 2000 on Win2000 Server/Win 2000Adv Server/NtServer (all) DB1.Table1 Identity Seed =1 Identity Increment ...more >>

I have sqlserver.exe running on my Microsoft XP Pro via the Visual Studio .net product, the student edition. sqlserver.exe starts up when the computer starts up. After about 10 minutes, I see sqlserver.exe getting 2/3 of the cpu time, and all programs trying to get to the internet, like ...more >>

Hi, Is it possible to set up a subsciber to a remotely hosted database where you don't and can't ever have sa permissions on the remote server? Our webhosting company tell us it can't be done. Are they right? Setup is a local sql 2000 box and a remote sql 7 box. Thanks Nick ...more >>

We are planning on replicating 10 laptops with a centralized sql server. Do we need to have a sql license for all 10 laptops? How about a SQL runtime enviroment without a full-blown SQL server install? Can we do that? Any other suggestions? ...more >>

Hi, I have transactional replication with push subscription. Both have sql2000 sp3 installed. When the replication reports this error: General network error. Check your network documentation. (Source: SAEECSQL (Data source); Error number: 11) ---------------------------------------------...more >>

We have a production database that was at one time replicated between 2 SQL Server 7 databases. After some time in this configuration, we decided that it was too much of a headache to maintain the replicated environment, so we stopped replication (without fulling cleaning up). Since then, we've mi...more >>

Currently running transactional replication with 1 subscriber. Primarily used as a high-availablity standby so the subscriber can update it's replica in the event of any failure on the primary. Additonal columns containing uniqueidentifiers were added to various tables being replicated b...more >>

SQL2000 transact replication. immedate updating subscibers. If I try to modify a table at the subscriber, I get the message that it "can't connect to the publisher because 'sa' is not defined as a remote login". Whew... any help appreciated. thx, Don ...more >>

Hi guys, My colleague unintentionally delted a database in SQL Server. Unfortunately the backup database is one month old. I tried to recover the mdf file but its gone already. Is there a a way to recover the mdf file so I can attach the database? Thanks, Jomax ...more >>

SQL 2000 Transact replication. Immediate updating subscribers. On 2 of 3 subscripion servers, I can't modify user tables even if I'm "sa" on that server. I get the error: "SQL server does not exist or access denied." All is well on one of the subscibers. Replication is working. I can ...more >>

Hi, I'm a system integrator and I'm using oracle lite 9i with 200 users with PPC in our solution for 2 years! We are going worldwide in our costumer with this solution and we are evaluating SQLSERVER2K & SQLCE as an alternative! I'm having some problems with Replication tests in SQLSERVER...more >>

Hi, I need help on setting up immediate updating subscribers. This is my current setup: Server A - publisher and distributor Server B - subscriber w/ immediate update I have transactional replication working and Server A is replicating changes to Server B. However when I try making ...more >>

Hi, I deleted a publication, in the Enterprise Manager I can see that the database is no longer replicated, however when I want to drop a table, I get an error indicating that the table is still replicated. Inserting or modifying records also fails. Does anybody have any ideas on how to cor...more >>

I had a database where the ldf was lost and no backups(a new database build). Replication was setup on this database. Now I cant remove the replication because of the suspect mode. I cant detach the database because of replication. Its a big Catch 22. I was however able to switch the dat...more >>

Hi, I have a problem replicating data over the internet. I have found out the reason of the problem. But I do not know how to resolve it. Here goes - My SQL Server is running under the servername 'COMP0220'. I made this as a distributor and publisher of a small database. After this I crea...more >>

Hello, I'm fairly new to replication so I'm testing Transactional Replication with Push Subscriptions. I'm replicating 6 tables to two different databases on the same server. So far when I modify/insert/delete data everything runs fine. But I'm trying to add a new column to one of the ...more >>

After I configured Publisher+distributor+push+subscriber. All the Replication Monitor folders in Enterprise Manager have RED check mark-means sth wrong. The snapshot was generated successfully. The push is failed with last action of 'Table 'XXUF0100' does not exist in the subscriber database'. I...more >>

Hello, I have set up Merge Replication on SQL2k on Win2k. How can change Stored procedure or trigger in Merge Replication on Publisher so that it automatically change to suscriber? Do I have to run on both (publisher & subscriber database)? Any help Appreciated Thanks -Nilay ...more >>

We have setup a transactional replication between a web server and a database server. When the snapshot is taken it sends back a status of successfull. Then the replication seizes. It does not give an error but gives this as the last command "C:\Program Files\Microsoft SQL Server\MSSQL\...more >>

Hi there, I am implementing a merge replication NT Publisher and Distributor W2k Subscribers Fails when the subscriber tries to retrieve data from the distributor. However It says that it cannot find the distributor. But the distributor is registered on the subscribers enterprise manag...more >>

Hi, I am using merge replication between MS Sql 2000 (sp3) and Sql ce server on the handheld (iPAQ). While creating the Publication I uncheck "Include declared referential integrity" and "Nonclustered indexes" for the snapshot. I am doing this because there are indexes that I need to use f...more >>

Hello! I have 3 databases: A - Contains table1 and table2 B - Contains table1 C - Contains table1 Replication is as follows: Article X is a merge replication on A.table1 to B.table1 Article Y is a merge replication on B.table1 to C.table1 Articles X and Y work great and data change...more >>

Hello, I want to set up Merge Replication on SQL2k/Win2k box. How can I change Stored Procedure or Trigger on publication DB so that change automatically replicate to Subscriber DB? Thanks -Nilau...more >>

Hi All We are trying to create a topology as follows on MSDE2000, in win2000 combination. We need to create the main server as a publisher and subcribe it into another server (2nd system). Then we has to make the 2nd system as a publisher and need to subscribe 2-3 client machines f...more >>

Does SQL Server 2000 Replication work on a Novell network?...more >>

Since this morning when we select the proprties of the Merge agent we get the error-message below. No restore of the database has been done. Error 14262:The specified @job_id could not be found" Error Message So we cannot change the or look at the properties anymore. Can anyone help wi...more >>

We need to set up a system in which interviewers take data on a laptop and twice a week communicate and replicate with a centralized database. Each interviewer will have only a subset of the data corresponding to that interviewer. We don't want to replicate the whole data from the centralized ...more >>

BOL give me the error but no resolution. Error when configurating Replication up is: Error 20028: The Distributor has not been installed correctly. Any ideas on how to resolve this please....more >>

I am running Win 2000 Server & SQL 2000. I understand this first part completely, the second part of this statement is where I am unsure of how MS SQL will handle the situation. I created a transactional publication (Pub1) of a table (Server1.Table1) from server1 to server2, then create ...more >>

Hi, I have 4 Dev Servers. I want to do replication as like this... DEV1---->DEV2 DEV2---->DEV3 DEV3---->DEV4 DEV4---->DEV1 Which is the best for me, and also what type of Replication. If merge, the conflicts can how configured. Thanks in advance. Bob ...more >>

I've a clustered sql 2000 server. I'm trying to configure replication. I receive that the components are not installed. When I setup for installing I only have access to uninstall. How can I install the replication subcomponets?. Please, can anyone help me? ...more >>

Still having a problem with the Transactional Pull Subscription Time Out. I have identified the problem, but I need a solution to automatically start the syncronization after it fails. Is there a way I can test if a job has failed using TSQL and set the job to restart ? Are there sp_ 's to h...more >>

Hi Guys, my sql server system already using fail over clustering . what i need now is a stand by server in a remote location in case any disater like raid controller failure or fire in the server room i should be able to bring the stand by server online without any loss of data with minimu...more >>

Once I set distributor and get following error. SQL Server Agent on 'ServerABC' currently uses the system account, which causes replication between servers to fail. In the following dialog box, specify another account for the Service startup account. Then it prompt a menu to setup the "Servi...more >>

Hi, I have implemented Snapshot replication on my database server. The publisher, distributor and the subscriber are in the same machine. There is a database 'X' that gets replicated every night to database 'Reportdb' on the same machine. The snapshot agent is scheduled to run every night...more >>

Anyone have any advice on setting up bi-directional transactional replication? We have 2 servers with identical DBs that we want to make both publisher and subscriber, so a user ca log on to either and do work and have data replicated to the other server. Kind of a distributed environment with ...more >>

All - We are planning to setup transactional replication for one of our OLTP servers that is in place for over 3 years that will be used for real time reporting and DR purpose. There are around 450 tables and 680 triggers. Out of these 450 tables there are around 350 tables that have IDE...more >>

Hi, I've got a lot of figuring out to do to find the best way to do this, but I just thought I'd throw this question out and see if anybody can lend me the benefit of their experience... I'm developing a server app to collect real-time PLC data from initially one install site (but potential...more >>

I'm running transactional replication in a Windows 2k/SQL Server 2k environment. Once in awhile I have cause to update approx. 8 million rows on the publisher. My question is this. How high can I set the -ReadBatchSize parameter before I completely bog down the server/network. Using al...more >>

Hi, I am able to successfully create a merge replication between iPAQ with SQL Ce and MS SQL 2000. I have written an application that inserts rows into the handheld database and I am using C# with .net compact framework for that. I want to know when I use "Synchronize" method of SqlCeReplicati...more >>

I have a server ("Server A") which is a publisher and distributor for snapshot replication on a subscribing server ("Server B"). There are 10 databases on the subscriber who all receive the same updates from the pub/dist server. This will happen between two different network segments ...more >>

Just how important is it to have all machines in a data replication environment have the same system time? It would seem to me, very important, but I don't see anything about it in books or BOL. I'm thinking of running a third party program that keeps all servers synched to the same ti...more >>

We have a merge replicated table which has one column defined as the primary key and is clustered. We want to remove the clustering attribute from the table and add a new clustered index to the table. The new clustered index will contain a new column. The question is this, If the PK's inde...more >>