Hi Freinds, I am trying to establish a transactional replication between 2 servers in west and east coast. Database is almost 80GB in size and contains more than 2000 tables. At the first try , I failed to push snapshot to subscriber, I am getting timeout errors, also by current tunnel that...more >>

Hi, In my replication environment I am using merge replication to get access to our vendors to our orders. They should not be able to see the price information of the orders. So, I want to do something like horizontal partitioning. I realize I could just leave the columns out of the artic...more >>

I am doing only one way TR, when snapshot agent is scheduled for daily (is this correct?), because my database have 107 tables, out of which 73 have primary keys, we want these tables should be transactional oriented update. we also set up Snapshot Replication for 107 tables, which is working...more >>

Hi there all. In my installation there is a main online DB which replicates some of its data with transactional replication to another DB. I also use log shipping so that there is always a stand by server for my main DB. 1. With this installation, can I still keep backing up my log every h...more >>

Hi: You can disbale the publication for database by using exec sp_replicationdboption 'Northwind','publish','false'. This also removes all the publications for this database from the replication/publications folder. Before doing this, I also scripted all the publications. To publish ...more >>

Hi Guys - This may fall into a connection category, but I was wondering if you had the same problem specially when dealing with replication. One of our clients is having the following problems: 1) My client computers can see the server computer by name and/or by IP address 2) My ser...more >>

Dear friends, I have some small questions related to the replication please see if you can help me. 1. I want to add a article in the merge replicaiton which i can do with sp_addmergearticle procedure but i want that the snapshot should automatically run after the same. Please also sugg...more >>

When I do: SELECT @@SERVERNAME It returns NULL. How, and how can I fix. Thanks. Darin *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have parent and child tables both in publisher and subscriber and I have identical foreign keys in publisher and subscriber. However, sometimes replication will report foreign key violation for the data getting replicated. To troubleshoot, I dropped and recreated the foreign keys with â€...more >>

I am unable to to create a Pull Subscription via the Pull Subscription Wizard. Message says: --------- SQL Server Enterprise Manager could not create a pull subscription to publication ... Error 14234: The specified '@server' is invalid (valid values are returned by sp_helpserver). ----...more >>

Hi: I need to detach the databse to change its location and then attach again. If this database is a publisher in a replication, will detaching and attaching affect anything? I don't think so but i just want to confirm it. Thanks...more >>

When I ran the sp_script_synctran_commands to generate my custom scripts = for my Immediate Updating subscriber on the publisher, it appears the = script generated that I need to run on the subscriber is being = truncated. What can I do about that?...more >>

When or where does the Merge agent create a snapshot? Whenever I click on the "Explore Snapshot" button, I get "file not found". Yet (on this particular server), replication works perfectly. ...more >>

I am having some trouble getting merge replication working. I have 1 server acting as a publisher and distributer and another server acting as my subscriber. Both are running SQL 2000 SP4. I need both the publisher and subscriber to be able to update the database. One database is for internal ...more >>

as i have mentioned in the previous posts, I've 2 publications, one trans and one merge. If i don't have the constraints on the subscriber side... When I change something on the subscriber side in a merge, the change will go to the publisher. But, what does SQL do when an FK constraint is vio...more >>

Hi! I have a Windows 2003 SP1 machine (workstation) running with SQL Server 2000 and I also have a Windows XP Pro SP2 machine (laptop) running with MSDE2000a. Both machines has Client Tools installed. I do most of my development (programming) on my workstation but from time to time I nee...more >>

Hi, ------- Sorry for posting my question in this group. Isn't Micsrosoft going to create new forums for SQL2K5? ------- BOL states that the snapshot file(sparse file) is small when it is created, and gradually grows. But I tried on my databases (even big ones) and its size is the same as ...more >>

Greetings the SQL community. Heres one for the experts. I have constant merge replication setup and working between 2 SQL 2k machines, both machines with hyperthreading. 99% of data merges successfully. The 1% that confilcts is a result of foreign key ID's being inserted into tables befo...more >>

For a publication in SQL Server 2005, is there any limit to the number of subscriptions we can create in Pocket PC? If yes how many? We are developing Pocket PC applications using C#.NET and synchronizes using merge replication technique. -- Regards, Shanavas. ...more >>

I have a SQL2K box acting as Distributor and SQL7 box as a publisher. The LogReader on the Distributor is unable to connect to the Publisher. I get the following Msg from the Log Reader: The process could not execute 'sp_MSadd_repl_commands27hp' on 'SQL2KServerName\InstanceName' The two ...more >>

Hi, I am using MSSQL2000 SP4, merge replication with pull anonymous subscribers. I am trying to use dynamic filter to partition. I created a UDF, let's say dbo.MyFilter ( @HostName, @RecordId ) returns bit. My where clause in the filter is WHERE dbo.MyFilter ( host_name(), Id ) = 1. ...more >>

I've given the automatic range on one of the tables for replication and I entered 1000000 for publisher and 1000000 for subscriber. When the table is replicated, the id column starts with 278418. Why does it do this?? does SQL know not to count? or am i missing something in understanding?...more >>

I have setup transactional replication and its going fine since some time in testing. I was trying to remove one of the tables from publication, but it always says that i have to drop subscription inorder to drop table from publication. If I drop subscription and recreate new subscription a...more >>

I have successfully setup log shipping between my production SQL 2000 Server (setup in a Cluster) and my Disaster Recovery SQL 2000 Server (across a WAN) What is the best way if any to stop the log shipping for a extended period of time and re-enable it without setting up the entire maintenan...more >>

I have a merge replication and I inserted 5000 records in the main publisher and they were inserted in the alternate publisher and in 1 subscriber, but replicating in the other 2 subscribers is very slow is taking forever. And sometimes it fails by timeout. I see the server and sql is consumin...more >>

Unexpected EOF encountered in BCP data-file (Source: PTOLEMEUS (ODBC); Error number: S1000) Hi there all. I'm trying to install transactional replication between two DBs in the same SQL server instance. This is for only one table. The source and target tables have the same schema in the first...more >>

Hi, I have taken a back up of a database that was under transactional replication and was the subscriber. I have restored the backup on to another server as a stand alone database (no replication what so ever). I am now trying to truncate the transaction log as its taking a whole lot of ...more >>

Hi, I'm new to this group and this is my first post here. My servers have Merge replication set, on the Subscriber server, I have a Table named 'Passarvo', the ID column of this table is an IDENTITY(1.1) with NOT FOR REPLICATION. Now when I try to insert values to this table , example: ...more >>

I want to setup a linked server to MS Access. If my MS Access file in different machine, on EM, once I got into the New Linked Server page, General tab, what should I enter to the boxes: Product name, Data source and Provider string ? ...more >>

I'll create a new database called Client, has 1 table called Shippers (this will be the same as in Northwind). Can you guru tell me the steps to create a Publisher, Subscriber and then make them synchronize ? ...more >>

Hi, I have two way transactional replication from SQLA to SQLB. SQLB is our Distributor. All are MS SQL Server 2000 ENT on windows 2000 adv. The IP address of SQLB has been changed and it made replication down. Can someone please suggest what values should i change on the system tables. Is it ...more >>

SQL2K sp3 Howdy all ...its been some time since Ive been around these parts. I may need to start replicating to a denormalized DB. I tested this a while back and it was grueling. After spinning my wheels for a couple of weeks my then emplyer decided he wanted to keep the db as is so I just...more >>

Using transaction replication, I encountered the following error: The LSN (2081235:261:1) passed to log scan in database 'StarDatabase' is invalid. (Source: NTSV7 (Data source); Error number: 9003) Both the publisher and subscriber servers are SQL 2000, sp4. I ran a DBCC CHECKDB on the p...more >>

Ok I'm sorry for all the questions. But we had a replication that was deleted by accident and I've been trying to rebuild it and I'm getting all sorts of problems. Currently I've rebuild an anonymous merge replication for SQL CE devices. I've setup 100,000 identity ranges so they will not hav...more >>

Hey guys. I had posted a question some time ago regarding how to make my id col's nfr. Paul had answered it with this script. You guys are from MS, so you know. But, is there a site where you guys have these colstat's stuff explained? I also need to do the NFR for all the triggers (about 60) t...more >>

Hi, I have setup a publication that my program on my CE device will synchronize to. It connects and downloads the database fine, and the database file shows that data has been downloaded. But when I try to run SQL statements against the database, it says that the tables are not there. I also...more >>

Hello everybody, I am trying to build a merge replication between 2 servers i managed to create it between to SQLSERVER 2000 with no problem but now i am trying to do it between SQLSERVER 2000 and ORACLE server when i try to do a transactional replication it work fine between the two serve...more >>

Hi, all! I will greatly appreciate if you share your experience of the replication of large database. Our production database is over 100 GB. There is transactional replication of all the tables of the database to another server. The replicated database on the subscriber is used as failover...more >>

When i tries to insert a record at publisher the record is get deleted in the publisher instead of propagating to subscriber, this is not happening always. I am using two way merge replication Thanks Kailux ...more >>

We are now running a merge publication with ServerA (in our office network) as the publisher and distributor and Server1 (hosted remotely by our ISP) as a push subscriber. We are adding ServerB to our office network, and it will replace ServerA, so it needs to become the publisher/distributor ...more >>

What happens when I truncate log at publisher database to the transactions marked for replication that are not picked up by log reader agent...???...more >>

Hey. I'll have 2 publications, one trans and one merge. Trans will be for read only stuff(one way). Merge pub has some tables which have pk and some tables from transactional pub refer to this publication with a fk constraint. How would i set this up? do i replicate fk's on both publications...more >>

I have a table for which a subset of columns are being replicated. When I want an additional column to be replicated, the GUI (publication properties --> Filter Columns tab) alerts you that CHANGING THIS PROPERTY AUTOMATICALLY MARKS FOR REINITIALIZATION ALL SUBSCRIPTIONS THAT SUPPORT AUTOMATI...more >>

Why would a delete of a subscription & publication lock users in the = database? It is a large publication, but when I looked at the activity it was = doing a sp_dropsubscription, and I don't understand why this locks the = users out of the tables. What can I do to drop this old subscription ...more >>

Hello, I am currently in the process of setting up merge replication and am encountering some errors that I can not resolve. I hope that I am able to provide enough information, however please ask for more detail if necessary. While using the Replication wizard, my first error encountered...more >>

Hey all. I'm stuck on another problem. I have 2 publications, 1 is a server to server replication for backup purposes, the 2nd is a merge replication for SQL CE and handhelds. My problem is I cannot enable the identity seeds on articles I need them on because it says it hasn't been confi...more >>

I recreated occasionally unique indexes creating the primary keys (which were not created by default) on some tables on subscriber for the transactional replication. Now I have got the suspicion that the replication is missing some transactions. Did I break the replication rebuilding the uniqu...more >>

Can I do a merge replication or any kind of replication between SQL Server 2000 and MS Access ? ...more >>

Hi If possible using two sql 2005 express edition on different Pc make data syncronization. Or i need to have one sql 2005 express edition and one standard edition Tia Pupo ...more >>

If you restore the db you plan to replicate to another server, and then = setup Trans. Repl. with immediate update, without doing a Snapshot = Initialization (Taking the option that says data & schema are already = there) how do the scripts get created? The scripts that will do the insert/upd...more >>