I have an Windows account that runs all my SQL Server jobs and my transactional replication. (SQL Server 2000 Enterprise Edition SP3) I'm receiving a login failure every minute in my SQL Server errorlog. I check my replication jobs and their does not exist a job that runs every minute....more >>

I aqm trying to set up merge replication over the Internet using FTP. M subcriber always fail to access the site. Can anybody tell me what i a doing very wrong? it is sql 2000. I will apprecaite the steps necessary in setting u Internet merge replication bay --------------------------------...more >>

Is it possible to synchronize two sql server databases running on two different computers in two different cities through XML File,being small in size, if so, how ? Best Regards, Luqman ...more >>

I need to make an application which would syncronize the offline and the online databases. Now the online database can be either Access, SQL Server or Oracle. Once syncronized, the user can make the changed to the offline database and then again syncronize it with the online database. ... ...more >>

Many times I can run snapshot agent to published a database sometimes snapshot agent takes two hours to run. Snapshot agent snapped the database fine, but when creating subscribers it failed because some views or stored procedures has errors in it. I don't like deleting the stored procedures an...more >>

First..I hope this is the right newsgroup. When I back up a database, I created a new backup device. As I went through and backed up several dbs, I noticed it was all going to one file on my back device which was obviously increasing in size with each backup. Is this o.k. or should I create a ...more >>

Hi All My distributor agent is stopped while we got error with FK relation in that table. The error is like Call : CALL sp_MSdel_Order How i can resolve this issue Thanks John....more >>

1. In merger immediate/contineous update replication, it takes about 20 seconds before the replication kicks in after i make any changes to db on either side. and "Add" ) seems to be faster than "delete". Is there any configuration I can make to speed up the process? 2. The merge agent...more >>

I still confused with snapshot agents. What exactly does it do? If I changed the structures of the tables in the database. And when snapshot agent is schedule to run. Is it going to pick up the new table structures and replicate the new table structures to subscribers??? And also if I add new t...more >>

My client has SQL Server running with 100 seat license. The database and replication is setup on one box. I would like to move the replication publication to another sever. what is the license requirement...? As I understand the server requires a license per device. So, my client would only r...more >>

We have a time accounting application with 5 tables. We want to allow the agents to keep their time on their systems off-line and then replicate when they get back to the office OR via the internet. While Michael R. Hotek's replication primer {http://www.mssqlserver.com/replication/primer_p...more >>

I have 14 merge agent jobs that are replicating to two different SQL 2000 servers, They all run OK on their own but when i try to run them all together it will not let me restart more than 8 of them. They all run under the same user name. has anyone come across this before?...more >>

Is it possble to log ship with only two servers. Having a primary, and a secondary (Destination) also as the monitoring server....more >>

Hello, I posted a question yesterday and got no response. I will try to post the question in a different way and make it more clear. I am trying to create a merge subscription on a Windows CE.Net device. I am using SQL Server 2000 sp3a and SQL Server CE 2.0 sp3. My IIS connection is...more >>

I am having a problem where SQL Server 2000 SP 3 will not replicate tables that have more than 255 columns. I am trying to find an efficient way around this. Does anyone have any experience making this sort of thing work? Strategies? Etc...? Thanks, Jason/Dave jason.hodge@unishippers.co...more >>

I always successfully created a snapshot of Northwind database and Pubs database and published it. And I always successfully created subscribers database for these sample databases. Then I published my own created dabatase and many times I cannot created subscribers. A typical example is as foll...more >>

Hi I run a replication that works fine. but sometimes during night the firewall between the two servers will be restarted. This leads in the Replikationmonitor/Publisher/MyServer/Mypublication to an Error. The Push-Service says "General Network error". So this is not so bad, but I have after ...more >>

Hi All, I have SQL Server 2000 Instance like more than 30 characters including netboisname+instance name. When i am trying to set up replication on this instance for my dev database, it is giving error number: 14234.: The specified @Server is invalid (valid values are returned by sp_helpserver). ...more >>

HI, i have configured merge replication with pull subscription on sql server2000 sp3. Sometimes the replications fails reporting the error: "failed to enumerated changes in the filtered articles". When the problem began i investigated on the internet and found the solution that all the peo...more >>

When implementing log shipping, and doing a failover and system role change, althoug I am transferring all logins from the Master on the Orimary Server thropugh BCP and a DTS package, they do not seem to appear on the Master of the secondary server. Any ideas would be appreciated...more >>

I configured merge replication on a test DB in a test environment. One of the jobs added while configuring replication in Enterprise Manager is "Replication agents checkup". It runs every 10 min, my guess is, it checks for the activity of the merge agent. The "Replication agents checkup" job i...more >>

High, i´ve on the SQL2000 10 clients with replikation. All works fine over DUN. But the LDF File is now 4GB large (after 6 months), the MDF i can shrink to 80MByte. The LDF says that it needs 700000 Pages, thsi cannot be. How can i remove or shrink it with to have to disconnect and reconn...more >>

Any thoughts on how to replace a distribution server without starting all publications from scratch? The basic situation is that we have a lot of large publications (some require 10 hour snapshots) using a distribution server which has some hardware problems & my VP wants to replace the entire...more >>

Is there any type of event that one could hook into after a transactional replication is complete? I'm trying to process some data after replication is complete (at the subscriber), but I have to make sure that all the dependant data has come in. Also, is there any specific order in which the ...more >>

I would like to run the replicaiton publisher on a sperate server.. What is the licence requirement for the publisher server??? ...more >>

I would like to load the replicaiton publisher on a different counter only for the purpose of replication. What is the license requirement for the publisher server........more >>

What is the criteria/ recommended schedule for backing up the distribution database ? Daily ? John Yard UCLA...more >>

We are running SQL 2000 EI SP3 on a Windows 2000 Adv. Server We have recently setup a database for replication using transactional replication every ten minutes Shortly after implementing this, we started receiving integrity errors on the database on a daily basis Many of the errors are requiri...more >>

Hi, I just installed the Service Pack 3a for SQL Server 2000, and now I cannot add any publications. Everytime I try to I get the following error: Error 515: Cannot insert the value NULL into column 'step_name', table 'msdb.dbo.sysjobsteps'; column does not allow nulls. INSERT fails. The ...more >>

My transacstional replication fails saying another " another logreader agent for the subscription running Plz help urgent...more >>

I have SQL Server 2000 SP3 with a published database and two remote subscribers (SQL 2000 SP3) using continuous merge replication. Everything works well but this morning one of the merge agents was reporting this error The merge process could not update the last received generation (Source: Merge...more >>

Hi all! I tried to reach the answer on "Security" group, but no success, so I have to try here! SQL Server 7.0, NT 4.0 I have distribuition server, whose only role is to be a distributor, there are no user databases on it. I want to create login on that server, a login which can only check...more >>

Hi, I am receiving an error when first attempting to add a pull subscription. It is complaining about a user-function used as a default in a table definition. The user-function doesn't exist. I've included all user-functions in the publications but it is still trying to create the table befor...more >>

is there anyway around the bug preventing replication of more that 256 cols in a table? thanks in advance...more >>

Must this rule always take precedant when a conflict ocurrs? Is there a way to "post" two updates to a central publisher? ...more >>

I recall seeing a list of options when viewing the conflict window. I can't seem to select options unless I create a conflict situation. Is there an alternate way of configuring the conflict resolver? bob ...more >>

Changing the SA password at my transactional push subscriber causes replication to fail. Am I going to have to delete the publication and subscriptions for all subscribers and re-create them? I tried to delete the subscription and re-create it for that subscriber only, but it didn't wo...more >>

Hi everyone, I am trying to create a one-way replication between a master database and three satellite using triggers. In this particular case, SQL Replication is not available as an option, so I have to stick to triggers. Now, for the interesting part; I create a trigger that fires...more >>

Hi, We are using SQL 2000 Server as we are mystified why the 'Data Source Drivers' when performing a DTS, for instance, contain German, Portugese and Spanish drivers and not French etc... This is quite odd and I want to know how these got there. Does SQL by default create a list of th...more >>

Hi All I have central publisher with 18 publications with static filters and 1 subscriber each. I'm experiencing problem with merge replication when I update one ore more columns on the tables at publisher. The merge agent reports successfully merged updates but when I compare the data...more >>

Hi everyone!!! I am new to SQL Server and need to know how to automatically update a remote server on the web in certain time interval.(say every day 9PM) so please help me out. thanks in advance srikanth...more >>

I am trying to modify the publication I have by adding and dropping columns from multiple tables. How can I accomplish these using scripts instead of manually adding/dropping the columns? I want to avoid dropping all the subscribers and then recreating them again. If I can script the proce...more >>

When I login using my account, instead of the local administrator account, and try to click on a publication I receive the error, "Replication does not support nicknames "local". I have noticed that the local SQL server is registered as "local" when I log in as myself, but it is registere...more >>

SQL 2k, sp3a I want to add another table into an existing publication. What happens when I do this? Does it automatically send just the 1 new table to the subscriber? Or is the entire publication sent over again? I'm hoping not that, because it's about 10GB of data, and the 1 table I want ...more >>

When I try to log in as myself (instead of as the local administrator), and connect to a publication I get an error that says, "Replicaton does not support nicknames such as "localhost"". I've noticed that the local SQL server is registered as "localhost". Should I delete and re-reg...more >>

I am synching replicas through code and i can't figure out how to get the status of the synch to display to the users. This code that I found in the help files does not explain how to plug it in. Can anyone offer an explaination of how this status event works? Do I make up the message and percent t...more >>

Hello All I have three server, a distributor, a publisher, and a subscriber. I setup the distributor and allow the publisher to use the distributor without any problem. However, when I try to publish a database in the publisher for replication I get the following message: SQL Enterprise Manager co...more >>

Hello All Could anyone me solve this problem? I got this error: 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option 'publish' of database 'test' has been set to false Thanks Tuoc...more >>

Here is my problem I have a table which has an Identity Column set as follows (as part of Merge Replication in SQL2000) Identity: Yes (Not For Replication Identity Seed: The problem is that I can insert new records at the publisher but not on the subscriber The constraints (on the Identity C...more >>

Hello all, I'm having problem setting up replication. My pubisher's service pack is SP3, my distribution and Subscriber servers are SP3a. I cannot update SQL SP for the publisher because the applications is not certified SQL SP3a. The error: The distribution server did not install correctly... My...more >>

Dear Friends I want to remove one article from the Publication of merge replication. The table name is sales and we do nto want to replicate teh same data. please suggest. Best regards Sharad...more >>