Hi, How do I automate the successful / error working of replication - both transactional as well as merge. Is there any system tables based on which i can do a join? Appreciate if someone can provide a query... regards. bharath...more >>

I need to do dynamic filtering on rows. I would like to use the pocket pc's device name which i assume to be the result for host_name() function under SQL Server 2000. I manage to setup everything and when i do a sync from a ppc device in a program that i wrote, it copies only empty table over w...more >>

Hi, I have setup a one way transaction replication. During creating the publication Artical, in the 'Commands' panel, I have checked all boxes in that panel including Create the stored procedures during initial synchronization of subscriptions. During creation of the subscription, if I...more >>

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 >>

When I am trying to Shrink CRM Database log in SQL Server the transaction log says that users are connected to the Database. How to clear the Transaction log when users are connected to the Database.If not how to clear the Log when the Databases are in replication mode. Ram ...more >>

In a replication topology with multiple subscribers, how do you bring the system back up quickly if the main publisher suffers a catastrophic failure and must be replaced by a different server? Assume that the subscribers continue to process transactions while the publisher is offline. Also as...more >>

Hello, Can someone tell me which is better to use pull subscription or push? Thanks -Nilay...more >>

hi everyone, I have managed to do a merge replication between a sql server 2000 database and a microsoft access xp on a local computer using Jet OLE DB setting at sql entripise setting. After sync, the replicated table at the Access cannot be added to the database relationship or added i...more >>

I'm in the process of designing a SQL 2000 design that will use log shipping to maintain a backup server in case the primary SQL 2000 goes down. I understand the implications of using log shipping vs replication or clustering, but one of the specs of the system is to have the backup server be one t...more >>

I have 4 boxes for Development/Production running SQL 2K w/SP3 Replication. My Development setup is same as Production (1 Publisher/1 Distributor). If I look at my Merge Agent properties on my Development Distributor I can see the MetadataRetentionCleanup property in the Default Merge Agent pro...more >>

Hi there; I have a very strange problem. We are running merge replication for a while and it just stopped working overnight. I am no longer able to create a snapshot.It stops with the message: An exception occured in the Snapshot subsystem. I browsed the newsgroup and someone suggested to run...more >>

Hi All I have a problem: When I created merge replication, system tables , named like aonflict%, conflict%, conflict%... (% is a string) , also were created. Now I disable replication and I want drop these tables. I can not drop them. How can I drop these tables Many thanks for help Nguyen ...more >>

Hi How to change the data type of a column without dropping the merge replictaion Thanks San...more >>

If i want to replicate all schema(tables,stored procs,views,indexed views and functions) and data obviously , do i need to make one publication or seperate for views and indexed views and functions as views need to depend on tables being created and indexed views on views and functions on tables ...more >>

I have defined a merge replication scenario since both subscriber and publisher need to update data. I have a table that has a numeric field that, if there is a conflict, I want to add up. I have defined this article to use "Additive Conflict Resolver", but somehow it does not work as I expe...more >>

what must a database be set to in order to participate in replication? here is my situation... i have a database that is marked for publication. I want to shrink the database and the data file. the recovery model for this database is Full. am i able shrink the database (that is mark...more >>

I established a transactional replication. I want to add not for replication attribute to the identity column using Query analyzer. Surely, By Using Enterprise Manager is easy. but I want to know the method using SQL. I tried to write sql query as below.. ------------------------ create tab...more >>

We have exactly the same problem as it is described on the Microsoft Knowledge Base Article - 814916 page (http://support.microsoft.com/default.aspx?scid=kb;[LN];Q814916). I'd like to know, why we have to contact MPSS and pay to get this fix - is this common policy for solving bugs or the reason...more >>

I am running Win 2k & SQL 2k. I am using transactional as well as merge replication and one of my SQL Servers is showing an error (the red circle with the white X in the center) on the Replication Monitor. When I expand the Replication Monitor an error is shown on the publisher folder as...more >>

Hello All, I try to setup replication for disaster recovery project and I ran into this problem. All my primary keys in my subscriber database are gone after the snapshot agent ran. Does anyone know why? Before I setup replication the subscriber database has primary keys. Please let me kn...more >>

I have replication installed on a SQL Server 7.0. The msdb database is suspect and now replication is failing. Other than uninstalling/reinstalling SQL, what is the fastest way to recover the msdb database? I tried running sp_resetstatus 'msdb' in Query Analyzer but I get the following me...more >>