Prev: Compact 3.5 - replication - IIS
Next: identity value is not reseeding in subscriber
From: I would like a replication that not ex on 8 Mar 2010 13:53
Thank you for your response.

I don't understand what command to execute to get the name of these agents?
Another question: It is possible to let the name of these agents constant?
Indeed, when I drop the replication and I recreate it, the names of
replication agents increments.


"Ben Thul" wrote:

> The tables you're looking for are at the distributor and match the
> pattern '%agents'. I found 5 on mine: one each for snapshot,
> distribution, merge, queue reader, and log reader. The contents of
> these tables should be what you're looking for. Hope this helps.
> --
> Ben
>
> On Mar 5, 4:46 pm, I would like a replication that not ex
> <Iwouldlikeareplicationthatno...(a)discussions.microsoft.com> wrote:
> > Thanks a lot finally it works!!!
> > Please how can I get the name of the replication agent. For example, when I
> > drop the replication and I recreate it, the name of replication agent
> > increments:
> > EXEC dbo.sp_start_job N'STANDARD-base-base-5' ;
> >
> > So how can I get this name to let "sp_start_job" with a variable having as
> > value the name of the replication agent.
> >
> > Thanks a lot for your help.
>
> .
>
From: Ben Thul on 8 Mar 2010 14:34
It's not a command per se, but a query against one or more of these
tables in the distribution database. For instance, let's say I was
interested in getting the information about distribution agents. I'd
get the information from the MSdistribution_agents table by running
the query "select * from MSdistribution_agents". If you want to get
fancy, you can join that table with other tables in the distribution
database to get the information for specific publisher/subscriber
combinations, but I leave that as an exercise for the reader. :)
--
Ben

On Mar 8, 12:53 pm, I would like a replication that not ex
<Iwouldlikeareplicationthatno...(a)discussions.microsoft.com> wrote:
> Thank you for your response.
>
> I don't understand what command to execute to get the name of these agents?
> Another question: It is possible to let the name of these agents constant?
> Indeed, when I drop the replication and I recreate it, the names of
> replication agents increments.
 | 
Pages: 1
Prev: Compact 3.5 - replication - IIS
Next: identity value is not reseeding in subscriber