Hi All: I have setup Merge Replication (Push) & we are using SQL2000 sp3. After testing a few things, I disabled the Publication. This did not remove Subscription on the other Server. I have a task stuck in Subcriptions, under Replication on SQL. It Shows the Task as 'Running' Status and Last...more >>

I have compiled the demo app and deployed onto a device, however, it will not replicate and I can't get pas the first screen that asks for the server name. The SQL Mobile .DLL files are accessible on HTTPS on the IIS (hosted on Windows XP SP2, Firewall is turned off) through a normal web brow...more >>

I have a strange problem I can't seem to figure out. Hopefully someone can point me in the right direction. I have a database I'm replicating with a number of tables that have identity columns as part of their primary key. I'm using merge replication and use automatic range management f...more >>

Hi All, I have Sql-Sever 2k SP2 and Win2K SP4 Advanced server. Topology : Republisher Publication Type : Merge with dinamic Filtering. Error on the Publisher : Failed to enumerate changes in the filtered articles {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?)} Merge Replication Pr...more >>

Hello replication guru's; I'm planning to implement a SQL2000 transactional replication republisher model. My question is, when you need to manually re-snapshot the data to the Publishing Subscriber, how do you handle the subscribers to it, i.e; Do you set up table articles to delete all ...more >>

I currently have one SQL server running locally serving 15 people and several MS Access, VB, and Web applications. We just recently merged with another company 1100 miles away with 30 plus users. They want to start using the same applications and have the same response times we have locally. ...more >>

Hi, I'm trying to use Alternate Sync Partner. I have found this how-to http://support.microsoft.com/kb/321176 but when I execute procedure ( step 9, my names are different :) ) sp_addmergealternatepublisher @publisher = 'PublisherA' , @publisher_db = 'TestA' , @publication = 'D...more >>

Hilary/Paul. I have a couple of questions: 1. Does the log reader start to read once you have setup a table for publication? Or does it' wait till you have actually "pushed" the subscription out. For example. I setup a publication for a subscriber who is not online yet. They should ...more >>

How can I prevent a subscription to a transactional publication from expiring? Here's a brief overview of our situation. We have 2 db's on one server. One of the db's is used for update, the other is used for search and retrieval (read-only). Both db's have tables that are fulltext indexed....more >>

hi does ne one know why i keep getting the following erro message i have created a script which updates a certain column but i recive the following error. Server: Msg 18750, Level 16, State 4, Procedure upd_F1E69E45D5304681833AD6E92EE73B6B, Line 51 INITCOLVS: The parameter 'nickname...more >>

I purchased the SQL DMO book that Mark Allison participated in writing. I read the chapter on merge replication , however, the chapter only discusses the setup / config of merge replication. I am interested in the code where a user would click a button and start a pull subscription. Does a...more >>

Is it possible to replicate XML Blobs stored in a SQL database? If so, does it require any special add-on or service pack?...more >>

Hi Can anyone give me a helpful link or information on the pros and cons on the "byte by byte level replication" versus "sql server transaction replication". Requirement: I need upto second replication to a geographically remote site, so I was considering sql server transactional replicat...more >>

We are looking into options for bring up a second live business site using SQL Server 2000 Std edition. The databases will updated at both locations and need to remain in sync at both locations. Some the tables contain Identity columns. We have noticed Primary Key issues when we insert into...more >>

Hi guys, I'm trying to setup replication from an SQL Server 2000 Enterprise database to an MSDE 2000 database on one of my XP workstations. The server is running Windows 2003 Enterprise Server. When (on the server) I try to setup the server database as publisher, I get a message saying that...more >>

Hi, When going through the replication wizard to setup transactional replication the following error is returned when it starts to setup replication. SQL Server Enterprise Manager could not configure '<four part servername>' as the distributor for '<four part servername>' Error 18456: Login...more >>

I have an order header we'll call HEADER and detail we'll call DETAIL (catchy names !!) When I replicate new orders, I use filters: The HEADER article filter is like: Select * from HEADER where ordr_dte >= '1998-01-01' then The DETAIL filter is like: Select * from DETAIL where ex...more >>

I currently have a main database server and want to implement a backup server that replicates the data in my main server. What is the best method of implementing this? I really don't know where to start so even a pointer at some reading material would be helpful. Any advice will be apprecia...more >>

Hi, This is my first experience with using replication. We have two research partners that collect data for us at two locations i.e., they run our application on two xp clients using MSDE sp3 and we currently synchronize the data with a series of exports and imports. This seemed to be a lik...more >>

Hi I have set up transaction replication for a copy of northwind database, I followed the instructions from the SQL Server books online. I have done the changing of the identity columns to have attribute property as "(Yes) Not for Replication". Created successfully a distributor/subscriber o...more >>

I am trying to tidyup some remants of past publications. The only parts that seem to be left is the publication itself and the snapshot part underneath it. If I try and delete it from Enterprise manager I get the error: SQL Server Enterprise Manager could not retrieve information about publ...more >>

Hi, Seems I found how to brake merge replication. Actually I reproduced this situation on my test env. after we found it on production. OK we have SQL2K EE SP3a on W2k AE SP4. Suppose You create a table with few fields of different type (field1,field2,field3.etc.. rowguid) Then you publ...more >>

Scenario is as follows I have got Site1, Site2, Site3 and Site4. All Sites are publisher except site4 and Site4 subscribes to Site3, Site3 Subscribes to Site2 and Site2 Subscribes to Site1. When i Insert at Site1, it only gets replicated to Site2 not at Site3 and Site4. And if Insert at Si...more >>

SELECT DISTINCT BannerGroups.BannerGroupCode, BannerGroups.BannerGroupName, BannerGroups.BannerGroupContactName, BannerGroups.BannerGroupContactEmail FROM BannerGroups INNER JOIN Customers ON BannerGroups.BannerGroupCode = Customers.BannerGroupCode WHERE(Customers.CustomerInactive = 0) AND (...more >>

Hi, The identity range on the a table that is being published is filled up and is coming up with primary key constraints. Is there a way to get another range of values manually? Thanks ...more >>

Hi there, we are using merge replication with anonymous pull subscribtion, wrutten in active X control. Every things is working fine but all of a sudden all the new subscribtion having problem. All the new subscribtion i created can synchronize and data form server trasfers to the subscriber ...more >>

Hi all, does someone know any third party tool to manage MSSQLServer replication? TIA bruno reiter ...more >>

Server A & B: Single-stand-alone applications with ms-sql-server. database has same schema, different data, NO Rowguid column. In a production environment. Now I want to install replication and establish a Publisher C. How do I set up replication after the fact, without loosing th...more >>

I have seen similar questions before but no good answers. I have some batch procs that temporarily disable triggers using an alter table statement when they run. I get an error message "Cannot alter the table 'TableName' because it is being published for replication" when these procedures r...more >>

I have transactional replication setup between 2 sql 2000 sp3a servers running on 2 4 way Dell servers with 16 gig of memory each. The servers are running windows 2003. Everything is enterprise edition and the sql servers are using about 14 gig memory. We restore the database to the second...more >>

I have a replication job that can not replicate a view. Any ideas??? I am assuming the replication job relicates views that are associated with the tables. Is there a way to only replicate the table and not the view?...more >>

Hi There, I am looking for some information regarding the subscriber name (computer name) in the merge replication. I am using active x control to synchronize the data between MSDE and sql 2000. ..Subscriber = Environ("COMPUTERNAME") ..SubscriberDatabase = "Ultraline Sub" ..SubscriberDatas...more >>

Will you be able to replicate to SQL 2005 Express from SQL Server 2005?...more >>

Hello, hope this is the correct group. I am looking for an easy and safe way to create a copy of an existing live database and put it on the same SQL Server in a test database. Has anyone done this before? I am not an experienced SQL admin and will really appreciate your help! TIA!...more >>

hi, I am maintaining around 180 tables, out of these-125 have identity values I need set new SEED value and new increment values for these 125 tables Is there any easier way to do this? Thanks, Soura...more >>

Hi, I have several SQL Server 2000 databases with data replications. I would like to alert several admin workstations when a replication failed. I cannot use email alerts because the servers and the worksations are located inside an industrial LAN without SMTP server and without email clie...more >>

Hello: I'm wondering why my seed values for identity columns where reseeded. I use merge replication. I delete the publication, make some changes on tables design, execute the publication script and my seed values where reinitialized, but I can't reproduce the error again. I don't undestand...more >>

Hello All, I am very much thankful to you all for providing much needed help, and once again I am at the group with my query. In my replication implementation in which I have around 100 subscriber I need to decide what conflict resolution policy should be employed. We, in our implementation...more >>

I need drop a column from de replication, I'm using the Sp sp_repldropcolumn @source_object = 'ObjetName' ,@column = 'ColumnName' ,@force_invalidate_snapshot = 1 ,@force_reinit_subscription = 1 But when I runing thi...more >>

I have transactional replication. I have number of publications filtered by key value. Each publication has one push subscriber and doesn't allow pull and anonymous subscribers. Retention period set to 0 min and 365 days max. All commands now delivered to subscriber I've checked it with query:...more >>

I'm having some issues in restoring some files via the SQL Server. I'm restoring to a database that is set up in the SQL server that we usually restore files to. We are getting an error every time that we restore the file and it is stating that the file is not a valid Microsoft Tape Format bac...more >>

BlankI am using merge replication with SQL2000 SP3. On the publisher a = column was added to one of the tables. When I synchronize the database = with the subscriber, I get an error message saying: the schema script sp_repladdcolum <column..> could not be propagated to = the subscriber...error n...more >>

It it normal for a distribution server to have a lot of NETWORKIO time waits? Also, we have 1spid with about 500k key locks on it. At what point would a distribution server move that to a table lock? thx comb...more >>

As per the answer below, how do you 'change the owner' of a replication 'job'? Hoping for a reply, Shawn ----------- Hi I've got a win2k and win2k3 server both running sql2k sp3. There are 5 transactional publications on one and corresponding pull subscriptions on the other. Replica...more >>

If I click on the publication and look at the subscriber column the subscriber name has changed to REPL_DISTRIBUTOR. Why is this and how do i change it back to the name of the subscriber? Thank you in advance for your help. ...more >>

Dear Friends I am trying to setup the StartUp User Account for the SQLServerAgent. But when i click on the enterprise manager and SqlserverAgent >> Properties i am not getting the option (Enable) Service Startup Account option enabled. Please suggest what can be the reason and how i can...more >>

Hi, I'm have a wonderful time configuring replication on a set of tables and need some help in diagnosing an error that is popping up. Currently, I am using the transactional model with queued updating. I have a set of tables that contain text columns, so during the publication build I ...more >>

I'm using transactional replication with queued updateable subscribers. I publish all my 630 tables and I use concurrent snapshot processing. I don't use filters, all data is published I'm having a locking problem in the publication database when I initialize my subscriptions. The d...more >>

i got this error when i add a table as atricle but i am pretty sure the column exist in this table, anyone experences thos error before? thanks for any comments cheers...more >>

i got a really strange problem. i am doing replication DB from SQL to PDA with CE2.0, there are about 30 articles in publication, and one of them is call product table. it works fine when i add product table without row filter. the problem is when i add a row filter in Product table , it...more >>

Hi, I need to do the following through Enterprise Manager (EM). I need to copy the structure of all the tables along with their PK, FK etc and need to copy the data of only select set of tables (not all of them). I tried doing this in EM but lost the relationship between tables in the target ...more >>

Dear Friends Please suggest if there are any possiblity to give the access to the users who created the records and the same are in conflicts. Here i mean that i want to create a program with VB.NET which will promt to the user whos records are in conflicts. so that they can solve the...more >>