.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Rename replication distribution agents using the Job_ID in MSDistribution_agents

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Hi All,

I am trying to generate a scipt to rename the replication distribution agent jobs using the MSDistribution_agents table. I have found a way to rename the snapshot jobs on the Publisher based on the information stored in the job_id field in the MSsnapshot_agents table and I was hoping to do the same for the distribution jobs using the job_id and the information stored in the MSDistribution_agents table.

The problem is that the distribution agents are running on a different database on a different box and there is no way that I can associated the job_id in the MSDistribution table with any of the job_ids in the msdb.sysjobs on the remote server.

Can anyone tell me if the job_id stored in the MSdistribution_agents table corresponds to any of the objects on the remote servers? I need to do this on more than 6 servers so it is very tedious trying to manually rename the jobs everytime I have to fix/setup replication.

Thanks in advance for looking at this

View Complete Post

More Related Resource Links

Replication Distribution Agent: CXPACKET

I have a transactional replication that is growing in latency. The performance is Critical. Please guide how i can go about troubleshooting the problem. Please provider detailed steps. Thanks.

Replication Agents


Can someone provide a detailed explaination of

1.how Many Agents are at work on a Transactional Replication 

2.how they Work?

3.What is VLF and how does it relate? Thank you.

How to Rename a SQL Server that involved in Replication


Hi Everyone,

I've been looking for a solution to my problem..
I have SQL Server Instance1 and Instance2 on  Computer A. I configured the replication between 2 instances for some tables. The Computer name got Renamed to B. Replication has been failed

I even cant open Replication Monitor.. The error I'm getting is

"SQL Server Replication requires the actual server name to make a connection to the server. Connection through a server alias, IP Address or any other alternate name are not supported. Specify the actual server name"

So, I tried renaming the server with 'sp_dropserver' and 'sp_addserver'

i'm getting below error

"Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42
The server 'A' does not exist. Use sp_helpserver to show available servers."

I cant' rename the Computer since it's domain name
Is Uninstalling and reinstalling the SQL Server only solution??

Any help is appreciated...

Thank you

SQL Server 2008 R2 Merge error in Replication agents checkup job


We have a customer with three publications, one distributor/publisher and on subscriber using merge replication.

looking at the history of the job replication agents checkup, every entry shows a message of:

Executed as user: NT AUTHORITY\SYSTEM. The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active. [SQLSTATE 01000] (Message 20554).  The step succeeded.


Throughout the day this error still appears as this job runs every 10 minutes but replication works fine. The issue is at some point throughout the night the replication stops with that same message. Sometimes it stops at 6:00:00am, sometimes at 6:40:00am, others at 6:50:00am. All we have to do to fix it is go into the replication monitor and stop synchronizing and then start synchronizing and replication will run all day until it stops next morning - again.

What is causing that error message? I have checked the other logs and there is nothing running at those times. in addition, no one has logged into the server that early (they don't start arriving until 7:15 or later).

What can i do to correct the issue so the message stops happening.


Replication-Replication Distribution Subsystem scheduled for retry.



We have configured a Transactional Replication between two servers, information as follows, The Replication environment has absolutely no issues before Friday night. Suddenly we have received Alerts every couple of minutes and the distributor Job is keep on re trying.


We hope there is a network or Security Configuration change made in the Subscriber Server for this communication failure.


Is anyone please help me to resolve the issue would be very much appreciated.

Concurrent Affairs: Solving The Dining Philosophers Problem With Asynchronous Agents


We use the new Asynchronous Agents Library in Visual C++ 2010 to solve the classic Dining Philosophers concurrency problem.

Rick Molloy

MSDN Magazine June 2009

Wandering Code: Write Mobile Agents In .NET To Roam And Interact On Your Network


In artificial intelligence, an agent is a logical entity that has some level of autonomy within its environment or host. A mobile agent has the added capability that it can move between hosts. In this article Matt Neely brings mobile agents from the halls of academia to a dev shop near you.

Matt Neely

MSDN Magazine February 2006

Return of the Rich Client: Code Access Security and Distribution Features in .NET Enhance Client-Sid


Rich clients employ many of the features and conveniences of the operating system they run on, and the list of these features has been growing since the dawn of the PC. But as apps have migrated to the Web, the trend towards increasing client-side functionality has ground to a virtual halt. There are several reasons for this; chief among them are security and deployment problems. But that's all about to change. With the .NET Framework, you can participate in building the distributable rich client of the future. In this article, the author enumerates the pertinent features of .NET that will allow you to build safe, easily deployable controls. The features discussed include managed code, code access security, versioning control, Windows Forms classes, and isolation.

Jason Clark

MSDN Magazine June 2002

Detecting mobile device user agents in ASP.NET (Android)



Last week Android updated their software (changed the display from 480px to 800px) so all the mobile tweaks we made for our apps are no longer work on Droid Phones.

I would need to identify the User Agent(e.g. Android) and switch style sheets depending. (We don't want to redirect to another page, just switch style sheets).

Anybody know any lightweight solution ?

Thanks in Advance.

(we were using 480px pixels to identify if the user was coming from iPhone or Android and switched stylesheets accordingly.  If I changed it to 800px some desktop monitors and the iPad would see the mobile version and not the desktop version. Not good.)



Rename Top Level Site Name MOSS2007


Hi techies,

      is there any possibility of renaming the TopLevel Site Name in MOSS2007.

Ex: www.Moss1.com to www.Moss2.com

thanks in advance.



Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

merge replication system tables fragmentation issue

I have Merge replication going on in my environment. The problem is that system tables like MSmerge_content, MS merge _tombstone and MSmerge_genhistory are getting fragmented. We are rebuilding indexes time to time daily. But we want some good fix. Just send some good idea guys?

peer to peer replication, drop and add article of same name

We have peer-to-peer replication set up on our system (2005 EE). I would like to change the metadata of one of the tables (many of the tables actually, but right now I'm just trying to test out the process with just one table). As this is a high-availability system, I would like to stop the replication, make the changes on one node, verify that the changes are working, make the same changes on the other node, then re-enable replication. The ddl changes to the table are extensive enough that I have to clear them before executing. So I will handle re-populating the tables in a later step. Right now I'm just testing the process of stopping, doing ddl, then restarting. I am trying to implement this using scripts so as to minimize my clicking (and thus potential for mistakes) when doing it for real. I find that if I do the following process using the SSMS interface it goes smoothly with no errors (note that each step is conducted on both nodes unless specified): stop sync agents manually remove article: tblName1 with 'publications properties window' close 'publications properties window' make ddl changes to tblName1 (change column names, add columns etc. to a particular table) manually add article: tblName1 with 'publications properties window' re-enable agents But if I try the following, I get 'Peer-To-Peer topologies require identical articles in publications at all n

Transactional replication: Updates to one of my columns (sometimes) does not get replicated from the

hi, This is my scenario: I have a varchar(max) column on a table that is replicated to other servers. I have a stored procedure that does and update to this column and other columns on the table. This is done inside a transaction that also includes other updates. When I call the stored procedure, this one varchar(max) column's value is not replicated. When I just run the single update statement on its own, the value is replicated. Anyone know something about this? Thanks!    

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  

transactional replication and sp_MSupd tables

Hi thre, My target server keeps running sp_MSupd sp for different values in profiler and synch status shows "delivering replication commands" I keep waiting but this never ends. and ultimately we run a snapshot and it can't be applied. So recreate the whole replication again. It runs fine for a while but again, the sp_MSupd sp starts running on the target server and the replication goes down again. I don't know how to fix this. any advices?   Regards
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend