I created a new table in the database and used the sp_addarticle to add the table to the SQL Server 2000 transactional replication. Next I reinitialize the subscription and received the following error. This help resolve this error. Thank You, Dan Violation of PRIMARY KEY con...more >>

I have Main server as Publisher "MSER", 2 other server as subsriber "SUBSER1","SUBSER2", I want to add another server "NEWSER" as subscriber but the data must came from SUBSER2 using the same database. NEWSER is a subscriber in SUBSER2, SUBSER2 is subscriber in MSER. can that be done? if yes i...more >>

I have transactional replication between two 2000 sql servers. An it is working great during the day. Working hours for that company are from 10 am. to 8 pm. And then every morning with the first transaction that need to be replicated I got: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGO...more >>

Hi, i want ask, if someone knows some good books for getting information about replication and also links to websides. ...more >>

What order should I upgrade my SQL2000 servers if I am running a publisher on one server and a remote distributor and a subscriber on the second server?...more >>

Hello All As part of our company standards, we cannot use SQL Mail utility, provided as part of Microsoft SQL Server, for generating alerts. We use a third party tool that monitors PerfMon and generate alerts if some thresholds are set. Now, I set User Counters (using sp_user_counter[1..10]) to se...more >>

Hi I am getting the following error message whilst implementing a master-slave snapshot replication: Creating the DTS package for replication Sql server enterprise Manager could not complete this operation. ...more >>

Hi All I have two sql servers hold identical databases, and one database table contains a field of type varchar(7500), this field being used by users to enter some comments. Now both the servers contains the same records, but only in one server, the above mentioned field contains values for comment...more >>

hi, i'm trying to use Merge publication for replicating as it suits me better than any other. but when i do that it addresses some issues that seem to be changing my database tables. like it tells me that 'uniqueidentifier' column will be added to tables. and three others as well. i'm pretty mu...more >>

Hi everyone, I think I have got myself into deeper trouble than I know how to get out of ... so Help! :) I have been trying to set up replication on an existing machine. I have set up replication before and I have had no problems. I have done something during configuring the publication t...more >>

I posted a message a few days ago but the list that I download seems to have been truncated and my message has disappeared! Any ideas? ...more >>

I am trying to get log shipping working. Below are the details: 1. 2 servers (1 on w2k, the other on XP) 2. They are in the same domain 3. created identical userid/passwd ( on local mc on both servers) 4. SQL Server and Agent run using this created userid/password on both servers 5. Created ma...more >>

Hi all. I'd like to set up a replication using a MySql database as a subscription server. Is it possible? Reading BOL, it seems that is it possible to use a ODBC/OleDB data base, but it has to support transaction. Any suggestion will be appreciated. Thanks Ruggero PS: excuse my poor en...more >>

I am replicating a database that was created by another group. There are conditions where it is acting as if when a new record is created, the record comes across, but when the blob is updated, it is not being sent across. If I go in an manually change the record (some other field), the change co...more >>

Hi everyone, Is there any way I can increase the performance of a snapshot? I'm currently running sql2k sp3 and win2k sp4 with merge replication running between two servers at different locations (about 15 mi. apart). My database is over 200GB in size. My snapshots are taking longer and ...more >>

Hi, I have a merge push replication between 2 MSSQL 2000 servers. During the past 5 months I've experienced 2 instances of a strange problem. The Merge agent jobs disapears! There is no error message of any kind. The only thing I can do is to set up the replication from scratch again. Why? Am ...more >>

Currently I have two SQL boxes in different locations using a VPN tunnel both are on different networks and different AD's. The VPN is setup correctly with ANY/ANY passing traffic between the two just fine 130.1.1.23 = North (Named=SBWEBSQLSVR 192.168.1.150 = South (Named=SQL01OCSBT I can do a ...more >>

I am looking for a way to create a daily mirror copy of a SQL server 2000 database. I am not really familiar with replication at all... Thank you in advance, Mohamed...more >>

Hi there, I have a database called Db1 that subscribes to a main, database, MainDb, through a publication. The articles on this publication allow Interactive Conflict Resolution. When a conflict happens between Db1 and MainDb, the conflict resolver interface comes up and I'm able to r...more >>

I would like to add table to the publisher and the subscriber database that uses transactional replication. I applied the add_article with @article, @Source_Table, and @Destination_table. The table was added to the article but the schema or data was not added to the subscriber. What do...more >>

I've encountered a baffling syntax error when installing Replication and greatly appreciate your help. After installing replication on a new Windows 2000 server the Log Reader Agent displays the error "Line 22: Incorrect Syntax near '='. The step failed". When I manually run the log...more >>

I would like to create a new index on my table that is replicated in the Publisher atricle. What is the correct procedure to create an index on the Publisher database and then have the subscriber have the same index. Thank You, Dean ...more >>

Greetings, I am hoping someone can help and lead me in the correct direction on a situation my company's facing. We run and support MSSQL 2000. We have a project that requires access to data that is being collected from all over the US, but this data is all collected in an Oracle da...more >>

Dear Friends I am getting following error. You must rerun snapshot because current snapshot files are obsolete. (Source: Merge Replication Provider (Agent); Error number: -2147201021) Please suggest how i can solve the problem. Your earlier reply will be helpful. Best regards S...more >>

I've got a merge publication set up with dynamic filters. Every now and then, we run some data maintenance jobs that end up creating a lot of records in the MSMerge_contents and MSMerge_tombstone tables. After these jobs are run, the synchronization process starts slowing down dramatically. ...more >>

Hi, I have a replicated copy of a database on one server and the full database on another. The stored procedures are missing on the replicated copy. How to proceed to get them in? Thanks. Sam...more >>

Hi, I have two MS SQL servers of which one database needs to be merged. The distributor is the new "empty" server. The publisher has a subscription of an old server that I cannot delete. Before creating a new merge, I need to get rid of the old one. Does anyone know how? Thanks, ...more >>

Hi, How do I get to know the amount of data that was replicated between two of my servers? I need to know this as I will have to decide on the amount of bandwidth required based on this for our servers. Is there anyway to find out the same? Thank you in advance, Karthik. ...more >>

Hi All Am getting the following error when trying to insert a row into a table (in fact any table) that is involved in replication. "Cannot insert the value NULL into column 'msrepl_tran_version', table 'servername.dbo.tablename'; column does not allow nulls. INSERT fails." Anybody seen t...more >>

I must be missing a basic step. In sql ent. mgr. I right click on "replication" and select "Configure Publishing, subscribers and distribution". This brings up the setup wizard which, no matter what I do, fails at the end with the message "Error 18483: Could not connect to server 'csfpho...more >>

Dear Friends I have a table name Mytable. I have 15 fields in the same table. We have offsour office and there we need to replicate this Table but i want to replicate only 10 fields now the replication is working fine for all the 15 fields. please suggest how i can do the same. I have ...more >>

I am currently using merge replication between the East and West coast. I am trying to push the snapshot to the subscriber and it is taking a long time. BOL talks about copying the snapshot files to the subscriber manually but says nothing about how to apply the snapshot and get replicat...more >>

What is the Microsoft recommended procedure to add or delete a table or stored procedure, and insert or delete columns in a table within a SQL Server 2000 transactional replication article? Thank You, Dan...more >>

I have set up Transactional Replication on my SQL Server 2000 database. The article that I created has 250 tables and 13 tables with indexes. I created a snapshot to send the tables with data to the subscriber database. How do I obtain indexes on subscriber database from the 13 publis...more >>

I'm trying transactional replication between two SQL 2000 servers. I keep on getting a foreign key constraint error, does anybody know how I can work around this problem? Thanks ...more >>

We are in the process of consolidating our field servers into a single server, multi SQL Instance environment. We currently have merge replication running using dynamic filtering based upon the hostname of the subscriber. This, however, will not work in the new environment (hostname() re...more >>

can you use replication to replicate the Data Transformation Services ?...more >>

Hello I am trying to set up replication from SQL Server 2000 SP3 to DB2 7.1 in mainframe. On SQL-Server I setup a Snapshot-Replication and push-Subscription to the Host. We are using IBM DB2 ODBC DRIVER from DB2-Connect 8.1.4 to setup the subscriber. I created a Linked Server and can access th...more >>

Hello friends! Pls Reply me about the following QUERY:- I have once done Replication using two servers but it got failed and I have so many problems to remove Red cross mark from replication Monitor , I have deleted tables, procedure,views created on that date(replication date)from differen...more >>

When reviewing conflicts I highlight a conflict and click the View Button and nothing happens, it will NOT open the normal View detail. I can do this on 4 of my 5 Regional servers, but on one it will NOT work. It just started doing this in the last 2 days. Anyone ever seen this before? ...more >>

I am attempting to setup transactional replication for many databases, and have had success getting started, but am running into problems with primary keys. I was able to get my tables that don't have primary keys in the article, but those tables are NOT updated when changes take place on the p...more >>

Hi, How to drop a stored procedure marked for replication? If the new table added to the publishing databas, does it automaticly will be marked for replication or you have to it manually? Thanks,...more >>

I have a transactional push subscription that has no publication, which I cannot delete. On my publisher, I have no publications under Replication | Publications, but under Replication Monitor | Publishers | server_name | I see "dead_publication" where "dead_publication" is a publication I dele...more >>

I am using a transactional push subscription. After I changed the SA password at the subscriber replication failed. I tried creating a new subscription, but the distribution agent still fails. Am I going to have to delete the publication? Help please!...more >>

Hello, I am new in MSSQL. I want to prepare script for create my database on other server. Is there any tool which prepare object's creation scripts in proper order (includes tables, procedures, views, constraints ..) ? Thanks, Peter...more >>

I've had replication running for a while now. But suddenly I'm getting this error after going through the process of dropping subscriptions, dropping a table article to widen a column, adding the article back to a publication. Now after a synch or two, I'm seeing the error: 'setting sentgen too hig...more >>

Hello Chandrasekar Gopalan! On 21/01/04 u gave Answer to my Query I have more to Ask:- Query:- I have done Merge Replication for few tables, Which gets fail and Rowguid column is generated in these tables,I am again trying Merge replication for these tables Will this column(rowguid) whi...more >>