Hello everybody, Does anybody know why SQl Server replication creates lots of other SPs while creating real SPs, and all the names are like "sp_MSdel_MyTableNames", that sp_MSdel_ part is repeated in all of them. Thanks, Mathew...more >>

Hi NG I have a replicated SQL 2000 DB (Merger Repl). The DB has a single MDF and LDF file. The LDF file grows by ± 500MB per week I would like use the following script to truncate the LDF file on a daily basis. The question is whether this will have any effect on replication. R...more >>

I just received some great help on this forum on two way, bidirectional transactional replication. But I'm not sure it's really the best solution after finding out more about it. I'm working with 2000 servers btw. I see two issues that (I think) will make merge replication (or maybe more ...more >>

Hi! I have a question considering transactional replication: is there any possibility to compress the communication with server (I don't mean compressing snapshots) during synchronization? The thing is the replication will be performed with GPRS connection where real transfer is about 4KB/s.....more >>

I have been getting numerous deadlock errors in my Queued Reader agent and Distribution clean up agent. We are running transactional replication with immediate updating subscribers-with queued updating as failover. We have one primary server with 9 subscribers. My Queue Agent is set to ru...more >>

I'm trying to setup replication from an external web server to internal sql box. The internal box with do a pull subscription to external webbox. I ran snapshot and all works successfully. As soon as I try to run Pull subscription, I get an error a Collation Conflict on a table. I tweaked ...more >>

After establishing replication of a database in a test environment I am now working on monitoring the success or failure of the replication process. In implementing this feature I ran across several issues, some of which raised questions I would like to pose here: I am running SQL Server 2...more >>

1) SQL Server 2005 replication monitor has publisher trees under my publishers\server name. However I could not find way to sorting the publishers. 2) The whole distribution agent trees are missing. I usually use distribution agent trees of replication monitor of SQL 2000 to find out which ...more >>

When I run this script... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ declare @location as char declare @pubname as char declare @SerVerName as char set @location = '03' set @pubname = 'EDI for #03' set @ServerName = 'ROUSE03SERVER' -- Enabling the replication database use...more >>

Hi all, I have a problem whereby our main DB server has been off for an extended period over the holidays and as such the Merge Replication (default 14 days) has expired resulting in "Subscription Deactivation". I've found this, http://msdn.microsoft.com/library/default.asp?url=/library/...more >>

Current situation: - 1 central location running SQL 7.0 acting as a publisher and distributor in merge replication - 30 remote locations running SQL 6.5 and acting as subscribers - subscribers are pushing articles to central location twice a day We are planning to replace all servers with ne...more >>

Hi , I have set up a transactional replication between two servers : A is the distributor and subscriber and B is the publishers. It works correctly Published objects in B has new columns rowguid(uniqueidentifier) and msrepl_tran_version (uniqueidentifier) The problem is when inserting ...more >>

I have an issue on one of my test servers that I'm not entirely sure how to solve, and would appreciate any advice people have. We are not using replication on any of our DBs, and so far as I know this instance/DB has never been configured for replication. Currently, Enterprise Manager is say...more >>

I have two publications (with only one article in each) based on the same source table. Both of these publications have one pull subscription each. Using sp_browsereplcmds and querying MSrepl_commands, I noticed that replication queues up for these two articles. How can I check whether th...more >>

I need to add a rowguid to 300+ tables. Is there a way to script it? Thanks Jeff ...more >>

We're having a problem updating an article in one of our merge replication publications. Replication is holding a lock, during syncing a subscription, on the entire article and when we need to do an update we get timeouts. Is there any way to manage the locks that Merge Replication is using ...more >>

We are setting up a merge replication with laptops as subscribers. I read an article about altering columns in a table but want to verify the correct sequence of events to add or change articles after Publisher is created. For a new table: CREATE TABLE command sp_addarticle For a revise...more >>

I am using bi-direction Transactional and I have a table that has about 190 columns. However, the column ids (in the syscolumns table) range from 1 to 160, then there is a gap and the column_ids and they start again at 240 to 260. When I try to add this article to a publication I get an error ...more >>

Hi, I already have transactional replication setup between two servers (production server to reporting server). I have created a new table witha primary key and have added this table as an article to the publication. How can i get my setup to take an initial snapshot of the table and appl...more >>

Hi there, I''ve got a large table wich I have to replicate (snapshot would be fine enough) to another SQL2k Server. The problem is, that the network is very unreliable (Internet connection to China). Most of the time the connection breaks before the snapshot file is copied to the subscriber. So...more >>

Is it possible to create a trigger after creation of table during reinitialization? if so, how can I do that? Thanks in advance! ...more >>

To test SQL2000 replication, I enabled replications for NorthWind between ServerA and ServerB. ServerA was the publisher and distributor, ServerB was the subscriber. After test, I deleted everything about replication on ServerA, at last, I disabled replication. However, when I ckeck ServerB...more >>

I have created a snapshot replication between ServerA and ServerB, the snapshot file location is \\SERVERA\ReplData. Everything runs fine except the distribution clean up job fails every 10 minutes. The error message is: Executed as user: 'ACCOUNT_NAME'. Could not remove directory '\\SERVER...more >>

I implemented the above between 2000 two servers according to the following link : http://support.microsoft.com/default.aspx?scid=kb;en-us;820675 I am just testing on one table and put in NOT FOR REPLICATION on both servers according to the following: CREATE TABLE [dbo].[tbl_IssueTracker_Is...more >>

I am working on establishing replication for a SQL Server 2000 database, and created a SQL Server Express 2005 database to act as a subscriber. I have proceeded as far as establishing the distributor, publication and article on the SQL 2000 server, but I am unable, using Enterprise Manager,...more >>

Hello, reading about peer-to-peer transactional replication in SQL 2005 (http://msdn2.microsoft.com/ms152536.aspx), I would like to do the same thing with 3 SQL 2000 servers. Of course peer-to-peer replication is not available, but can anybody suggest a way to simulate this kind of replicat...more >>

If I create a transactional replication - Push method in SQL 2K standard with sp4, will replication create entries in the Remote Servers setting in EM? Currently I found three entries in the Remote Servers listing, server name for the publishing server name, server name for the subscriber ser...more >>

I use SQL2000 and Transactional Replication from server A to B. It is success to replicate the changes in "Add" and "Deleted" records. But, if I change the record in server A and then find that fails to replicate. In "Log Reader" in server A, I can see 1 log is delivered but no any changes in ...more >>

I am playing around with the new Replication Monitor in 2005. In the old Replication Monitor (SQL Sever2k), you could right click on a subscription and Start or Stop Synchronizing. So far I have not been able to find this feature in the new Replication Monitor and I've had to SQL Server Mana...more >>

The last news I read about SQL2005 is that Database Mirroring was delayed for further testing. Is now available? If not, when it will be? Thanks! ...more >>

We are using SQL 2K std sp4 and using Push transaction replication. We created table two months ago and was added to the article to be replicated. Since then we didn't create any new snapshot. Today when I tried to create a snapshot and thought it would create one for this table, the snapsh...more >>

I have set up Merge Repliction with only one subscriber. Everything is managed through Enterprise Manager. There is a job, REPL_Snapshot, that runs every Saturday night. One of the effects that is causing us a problem is that the conflict tables are cleared, probably because they are recr...more >>

I'm trying to replicate a table that now has more than 256 columns. SQL2000 chokes when creating replication with error 20068, stating that the maximum number of columns allowed for an article is 256. The workarounds I am aware of involve creating two tables and using views to abstract thi...more >>

Hi, When trying to push a subscription I am getting the above error. It's a 2005 database upgraded from 2000. I had disabled replication on the server before moving to 2005. The db has some 2000 tables, and recently I dropped many unwanted tables usin T-SQL and a table with 'useful tables' e...more >>

My Merge Replication was working correctly till New Year. The initial synchronization is always synchronous (I must have a database in order to start my application) and the rest of them are asynchronous. This scenarios was working perfectly. Now, without making any changes, initial replicatio...more >>

Hello there I build transactional replication that works fine. It work with scadular, and when i want to run it manually I: go to enterprise manager, running the agent that run the job of the transactional and it works fine The name of the agent is being changed when i remove and add th...more >>

Hi, I'm newbie on replication, so : I own 2 MSSQL server 2000 servers : - server A owns many populated databases (biggest is hundreds of Gb) - server B is fresh installed and have no databases I would replicate the server A over the server B so : - I configured server A as publi...more >>

Hi, I have a push replication for 4 quite simple databases. First problem was that all of a sudden it did not work any more (after 1 month without problems) - red crosses in the replication monitor. I finally found out that this problem is solved by updating to SP4. I did the update on t...more >>