Sorry for the long post but I will provide all small details if someone is curious to try to solve the problem. I have 2 problems: 1. I can successfully cancel the snapshot generation but when executing Terminate and error is thrown. 2. I can't get Notify event on SQLReplErrors. The eve...more >>

HI All, I have sql server 2000, with a pull merge at a subscriber. This expired after 14 days (I forget to turn off the option) The user has now been adding data to their subscription database for several weeks after the expiration. Question. How can we restart synchronising without losing...more >>

I have 35 gig db which is used for two publication: one transactional and the other a merge. We wish to archive 2/3 of the data off of the server. My question is should I stop the replication and rebuild it after the archive or should I keep the replication in place during the archiving p...more >>

Could anyone tell me what you would need to do to keep merge replication working between two servers when the subscriber changes IP address as in changing to a different subnet or even hosted at diferent ISPs? I presently know about the Port numbers/firewall issues and also the SQL Server...more >>

I attempted to change the bar chart columns colors using the Reporting Designer in Visula Studio .net (2003), but it doesn't work. Is there a way to do that in VS.NET? Thanks a lot for any help. Simona...more >>

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (Origen: (Origen de datos); Número de error: 18452) A que se debe esto, como lo soluciono? ...more >>

Hi there, One of our user had (and still has) the right to post DELETE commands to one of our main tables in the Database. I usually hate when managers has this kind of rights. Generate a lot of trouble. The scene is as following: he deleted some records from a very important table in...more >>

SQL 2K Something is wrong with my Transaction Log, and I have a feeling it's because of Transactional Replication. When investigating I noticed that althought Transactional Replication is enabled and apparently running, there is no "Log Reader Agent" - is that possible ? Richard ...more >>

Tables without Primary Keys cannot be Replication using SQL Server 2000. Can you use a Unique Index key instead of a Primary Key for Replication? Is there a work around so that doesn't have to use a Primary Key? Thank You, Dave...more >>

I have to create a transactional replication in SQL Server. Still while publishing, for a few tables I get the following: --------------------------------------------------------------------------- "SQL Server Enterprise Manager could not create article '<article_name>' based on object '<tab...more >>

Hi, I am wondering if there is a proc out there that would remove all the replication triggers from the tables? I am using SQL Server 2000. Thanks, Tim...more >>

sql2k sp3 I just ran the Validate Subscriptions tools in EM. Where do I see the results? TIA, Chris...more >>

Hi all, I've been racking my brains here, maybe some one can provide some explanation. Scenario: SQL2000 Ent. Ed. on three servers, A B & C SQL A - Located in Datacenter 1 (Primary) SQL B - Located in Datacenter 1 (Secondary, Warm Standby, LS Monitor) These two are set up for same site ...more >>

Hi, My customer has a specific problem with merge replication. They have a group of field based laptops (60+) all capturing orders in a SQL Database (SQL Server 2000 SP3). The orders are synchronised (using merge replication) with the main system database. These subscriptions are anonymous...more >>

I continually get a Distribution Agent failure whenever I a loose a connection (network error, server maintenance, etc.) to one of my push subscribers for about 20 minutes. Is there a way to increase this time so the agent will continute to try to connect for 2 or 3 hours instead of failin...more >>

What kinds of problems or errors that can occur, if I delete the contents in the Article Default for Replace INSERT/UPDATE/DELETE commands with stored procedures call? There are so many stored procedures that are created from the statement "default is based on table name". If I can dele...more >>

i have a statistics page that shows how many pages are visited by a user. some sad people are hitting refresh multiple times to get themselves into the top 10 users. How can i limit the number of times a user can refresh a page? *** Sent via Developersdex http://www.developersdex.com *** ...more >>

Dear All, Is replication possible between two different domain? I am using a standard version of SQL2000 that comes with the small business version (SBS). Thanks in advance ...more >>

hi, Im doing replication and facing problems bcoz of Identity field.. I've 2 servers as A and B. users will enter data in both A and B servers..but A server data will be replicated to B server..(not vice versa). now tables have identity field and pkey..i tried transactions replication..b...more >>

I have transaction log shipping and the server name has changed. Now I can't delete the management item as it says i need to register the server (which is now non-existent!) Help! ...more >>

Here are two machines A and B locating at different place.They are both installed ADSL. Now machine A transfers data using merge replication via ADSL to machine B,but it fails. SQL Server explain:Can not find subscriber B. Whether is there any configuration need to be done such as protocol etc ...more >>

I need to create a merge replication between sql 7 and sql 2000 pushing a view. When I push the subscription from the 2000 box I get the error that 'this type of merge replication is not supported by this version of sql, please upgade'. I am assuming this is referring to the sql 7 box because if I t...more >>

Hi all I'm a newbie to DTS and Replication. There are 2 databases in our enterprise. There will not be any more added to it. We need to regularly (at least 12 times a day) download information from three tables in A to B and upload data in two tables from B to A at different intervals - som...more >>

i need some assistence on how to apply the initial snapnot manually , of a database that is 3GB. i create the snapshot at my central site, but what i the procedure after that to apply the initial snapshot manually to my remote site. i can't do it over my vpn connection , because the file...more >>

Hi I have a table x which is in transactional replication with queued updating option. I want to change the one column properties varchar (15) to Varchar(100). What is the procedures for change Thanks John....more >>

I need to set up a push subscription from an SQL 7 box to an SQL 2000 box. I have the publisher set up and I need to set up a MERGE replication because we'll have to utilize both servers until we can pull all the connections off of the SQL 7 box. When I initialize the subscription to p...more >>

Hi everybody: I'm new in MSQL . I have programmed a backup task to make copy of master and another database each 12 hours. The problem is that when i did it i didn't ckecked the overwrite box, so the file increases everyday and i have to delete it. I have tried to program another backup job wi...more >>

Hi, I have established merge replication publication. On some articles (tables)there is a replication dynamic filter through which every user downloads data that is not older than 12 months. However, If I want subscribers to have only data for the last 12 months after every synchronization, t...more >>

The schedules Tab for a job has exclusive radio buttons: Start the job (i.e. the Agent) Automatically when SQL server starts or Recurring (this option allows to start the job every x minutes) but how to have both? because several times, the distribution agent hangs... a simple restart fixed the...more >>

Hi all, I want to modify my Identity columns and primary Key of my table and add "Not For Replication" to it. Please let me know if i could do this using Alter Table statements. Juno...more >>