I have re-initialize some subscription. After generated snapshot successfully, the synchronization view showing 'The process is running and is waiting for a response from the server.' and I found the replication process is under 'async_network_io wait'. The job has run for more than 8 hrs. ...more >>

Hi there, We are using SQL 2005 Merge replication between SQL 2005 Standard and SQL 2005 Express subscribers. We seem to not be getting database schema changes right. Each time we try to make changes to the database for which a publication has been created, there are errors for simple tasks...more >>

Hi all, I am trying to setup Transactional Replication from a SQL2000 box to a SQl2005 box. Here is what I have done:- 1. Configured SQL2000 as a Publisher and Distributor. 2. Setup the Publication and chose the database and tables on SQL2000. 3. I then created a domain account called "sql...more >>

Can someone point me to documentation on steps to setup a 2005 merge subscription (we are using laptops and SQL Express) without using Management Studio? I assume we would create "pull" subscriptions. Our old MSDE allowed anonymous and setup via Windows Synchronizer. Thanks. David ...more >>

I'm having difficulty implementing table-driven partitioning for a merge replication/pull subscription scheme (SQL2K, SP4). I want to use a view in the WHERE clause of the article's partition spec as: iOfficeNum in (Select iOfficeNum from dbo.vw_GetOfficeNumList) The view returns a diff...more >>

We have SQL 2000 server as publisher with 2 publications (tables and other). Our subscribers are laptops using MSDE. We are planning to move to SQL 2005 server and 2005 express soon. I know I can do a full backup on 2000 database and then restore it on the 2005 server. How can I maintain ...more >>

I have worked w/ replication on many different sites, so I know how to setup merge and contiuous with no problems. Now, we need to setup a laptop that has a subset of the data. This laptop currently has nothing on it, so I would load the program and MSDE. But, what data should I first get ove...more >>

Hi, I have setup a Pull Subscription on a laptop to one of our SQL 2000 servers. It works fine, but when I use MS Synchronise, each time it asks to enter password and confirm password for Subscriber Login and Publisher Login. Is there someway to save these passwords so they don't need to b...more >>

Hi, I'm getting the 8152 ("String or binary data would be truncated", and = sometimes "General error") error when running the EMs "Configure = Publishing and Distribution Wizard", on executing "Configuring = Distributor" step. I'm trying to set the server to act as both the = publisher and it...more >>

hi, in SSMS (SQL 2005) I don't have global view of transactions i dont' have with one look all transactions runs i don't know if the transaction have problem quickly... how can i resolve it ?? Program, extension ??? ...more >>

All servers SQL2000 sp4. Have subset of tables setup in merge w/ 5 subscribers (order entry / front end servers). Have all tables setup in trans repl at pub to report/backup server, including those tables in merge w/ FE's. So request from dev to add column to a merge table, I only pickup...more >>

Hi, I am facing a problem while monitoring the registry value that is set when the replication is configured on the machine. When I newly installed SQL Server 2000 using the default settings, the value of the following registry value is always set to "1" even if the replication is not configu...more >>

Hi all, I have a large db that I'm going to set up relication to replicate to a different server. it's about 300 tables and a lot of tables with milion milion rows of data. This is a vendor's db and the schema is going to be changed very week through SQL scripts. Questions: 1. what is...more >>

Greetings I am getting the following error on repliation of a SQL 2000 server: "Length of text, ntext, or image data (66321) to be replicated exceeds configured maximum 65536. The statement has been terminated." Web posts advise the use of sp_configure 'max text repl size'. Is there a set...more >>

Has anyone tested merge replication with a SQL2000 Publisher and a SQL2005 Subscriber? We have 1 pub, 5 subscribers, would like to migrate subscriber servers to sql2005 one at a time if possible... then finally upgrade the pub last. Thanks in advance, Chris...more >>

2 machines both running Windows 2003 w/ SQL 2000 SP4. One machine is publisher & distributor, the other is the subscriber. Last night, somehow the SQL Server program on the distributor got corrupt and won't start (get the error that a file is missing). So, I believe our only hope is to re-ins...more >>

I am looking list of error messages for SNAPSHOT & TRANSACTION REPLICATIONS. any help about the lists or links from where i can get/find list of replication error message will be highly appreciated. Thanking you in advance....more >>

Hi All, Can someone please provide me with some advice on how to manage the rowguid column of a dataset when using Merge Replication from SQL Server Mobile 2005 to SQL Server 2000 ? I have a windows forms 2.0 application on a smart device (SQL Server Mobile 2005) that synchronises to SQL...more >>

Hello, I am a newbie to replication, I recently came up with this error. Cannot use DROP VIEW with 'dbo.vw_UndeliverableEmail' because 'dbo.vw_UndeliverableEmail' is a table.Use DROP TABLE. I tried running these two queries to make sure. SELECT * from syscomments where id = object_id('v...more >>

Hello, I am looking for information or tools on how to find out what part of our replication setup is causing a high bandwidth usage across a T-1 line. This started when we upgraded the main server to SQL 2005, with the remote server remaining at SQL 2000. Please read below for the scenario...more >>

How can i permenantly drop the "Distribution" Database as I already disabled the replication function [publication, distribution & subscription]. I not able to drop the database. Why?...more >>

Hi all, I am currently in the process of evaluating MS SQL 2005 Mirroring in a test lab environment and got a bit stuck when trying to setup a 3rd server as a witness server. I initially started with the principal and mirror servers which work fine, but now want to add the witness server...more >>

Hi, I am using merge replication, the following error message occured in my replication 'Column names in each table must be unique. Column name 'MSrepl_create_time' in table 'conflict_DATABASENAME_TABLENAME' is specified more than once. (Source: (Data source); Error number: 2705)' The a...more >>

Hi , Currently, i have set up a txn replication and my snapshot agent will run a check at 11:00 pm every nite to see if any new snapshot needs to be created. What i need now is , i'll need is to force a new snapshot or reinitalization irregardless of whether the subscription needs a rein...more >>

SQL 2000 and Merge Replication. I have 2 publications; 1 for tables and another for views and stored procs. I have 1 or more triggers that are no longer needed. If I remove them from the Publication will I need to recreate the agent snapshots for the subscribers or will they just pick up ...more >>

Hi, I need to execute a script at the subscriber when ever a snapshot is applied to it. However, i would like to read some data from the publisher's table and apply it as parameters to the script. For eg: I would like to know the publisher's host name and list of unique id(s) in one of its pu...more >>

Hi, I would like to get an answer to a problem am facing now. Problem statement goes like this - Have setup transactional pull type model between local distributor and centralised subscriber (SQL 2000) using TSQL scripts. There are 4 tables which have primary keys also replicated.The setting ...more >>

Hi, I have a single publication. - It contains 29 tables - There are 7 tables that are using a Filter (HOST_NAME()) The rest of the tables do not have a Filter and when the subscribers connect, they are not getting the changed records. What do I need to do or look for the changed record...more >>

I need to change the recovery Option from FULL to Bulk_logged on a database I am replicating .. is this going to impact the replication processes since there will be minumim logging this is production database? Thanks, Omran ...more >>

Hi, We have SQL 2005 Enterprise edition installed on our Hubs and experience a MAJOR BUG of merge replication. Data is NOT being replicated on some columns. Here are the repro steps. 1) Create a database TestPub, with a table 'Test' having the following columns: a) rowguid b) C...more >>

Hi all I have a SQL2000 (SP3) Server acting as publisher+distributer, It has a database published for merge replication. Database size is 8GB and it has 13 tables. Right now it has one push subscription that is working fine, i want to add another subscriber to it. When i add the subscrib...more >>

I need to change the recovery Option from FULL to Bulk_logged on a database I am replicating .. is this going to impact the replication processes, this is production database? Thanks, Omran ...more >>

hello, I have a table whose base is in replication on another server. I have to add a field in this table. The snapshot is rebuild and it's ok, however the replication are in stand by. how can i start transaction, but not with the reinitilize ??? Help, ...more >>

Hello, Background: Two servers running transaction replication, with the subscriber pushing queued updates. Both servers run SQL Server 2000 sp4, Win2k3 sp1. In preparation for an application change, some of our publication articles needed a schema change. Rather than dropping the full...more >>

I am attempting to create a merge replication publication on SQL Server 2005 Standard to support SQL Server 2005 targets. The snapshot agent completes successfully when I use tables that do not include XML columns. However, if I include a table with an XML column I get the following error ...more >>

Can you and should you back up the transaction log while a database is in mirroring state? I was under the impression that you can't back up the log while mirroring because it would throw the mirroring sequence off. However, it looks like my used log space is growing, and I'm concerned that ...more >>

I have question about Replication Alerts & error messages. The SQL Server 2000 that i support doesn't have MS Outlook 2000 as the licensing is cost thousand of dollars & they don't want to purchase, bcoz of price factor. I know that SQL MAIL requires MS OUTLOOK 2000. I need your help if there ...more >>

Hi I have a pull merge replication and experience that records are deleted on publisher and it seems to have something with the order things are done. 1. the publisher is initialized and replicated 2. some records are stored on publisher 3. the publisher replicates again and the replication d...more >>

This is a follow up from a posting I made earlier (http://groups.google.co.uk/group/microsoft.public.sqlserver.replication/browse_thread/thread/c7e9c219f517444e/2aaad21b9c9defbf#2aaad21b9c9defbf) I logged this issue with Microsoft PSS and it has now been logged as "SQL Bug". I am still awaitin...more >>

My net connection between my publisher and subscriber sucks big time. If i can't connect to the subscriber, i have set up 100 retries, one each 5 minutes (the net goes down for more than 8 hours sometimes!) The problem is that i get a bunch of errors during the day, on the merge publications o...more >>

Hi, I have a db with a few tables which has owner than dbo. When i use this db for merge replication it creates tables with owner as dbo on the subscriber. In order to avoid this i went to the article properties on the publisher and changed the destination owner to the 'other user' not 'dbo' a...more >>

Is it possible for sql 2000 to replicate (publish/distribute) to SQL 2005 Express? We've been replicating to MSDE but we are close approaching the 2gig limit and we need to find a solution without having to upgrade our server to 2005. Is this possible? If not, any potential solution worth lookin...more >>

Hi I am trying to replicate tables with foreign keys in MSSQL 2000 When I publish the tables I have "Declared Referential Integrity" Checked. When the Snapshot is reinitialized I have a stored procedure that I run on the subscriber to drop the foreign key constraints and re add it with th...more >>

We have been building databases for replication and therefore using primary keys of type uniqueidentifier. The GUI is developed in Microsoft Access 2003, which doesn’t seem to allow us to insert NULL values into the foreign keys (of type uniqueidentifier) that reference these primary keys. T...more >>

Hello, I've been searching for information on this for awhile unsuccessully. I am using SQL Server 2005 Enterprise Edititon and transactional replication with separate publisher, distributor and subscribers. I need to encrypt data on our publisher and then I need to replicate that data ou...more >>

My publicer is database server in domain, and subscriber is a server out of Domain ... can i push it? I try to do it but it still show error 14053, I have searched on the internet, there are many solution to suggest me check sp_replincrement, sp_replincrement_internal and check file c:\prog...more >>

I am watching merge replication running via the replication monitor, and it is working fine. But, since it has been running for about 7 hours I would like to see what is left to replicate. Is there a way (SQL script or table or whatever) that I can see what tables/columns need to be replicated...more >>

Hi, I'm trying to configure Oracle9i to sql server 2005 replication, but the wizard does not find any tables to publish. I granted the privileges to a user with the script in books online, and this user owns some simple tables. I had no problems configuring the publisher, and I can sele...more >>

Having written a custom resolver (or business logic component) dll and plugged it into SQL Server and merge replication and then debugged it, I found that the data was not what I had viewed before exiting the debugger. I had successfully merged some data where I had conflicting updates at p...more >>

where can I find a step by step introduce of oracle to sql2005 replication?...more >>