Re: SQL Server 2005 replication monitor questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Where is it that I find Enterprise Manager and SQL Workbench? I don't have
either of those on my machine. How do I get them installed, because it
appears that I need them.

--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OurvJ3uEGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
> It seems to be the order that they were registered in Replication Monitor.
>
> To get to the agents expand SQL Server Agent jobs, and see if you can
> identify it there. Otherwise, click on your publication in Enterprise
> Manager, and in the right hand pane, select Warnings and Agents. In the
> bottom half you will see your snapshot and distribution agent. To manage
> the snapshot agent, return to SQL Workbench, location your publication in
> SQL and expand Replication and Local Publications, right click on your
> publication and view Snapshot Agent Status - you can start, stop and
> monitor it there (through replication monitor).
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Charts" <Acharts@xxxxxxxxxxxxxxxx> wrote in message
> news:496EBAA0-AB4B-4ED2-BF53-009C26402877@xxxxxxxxxxxxxxxx
>> 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
>> publications are currently running, but I cannot find the similar
>> utilities
>> in 2005.
>> Appreciate for help.
>> Charts
>>
>
>


.

Relevant Pages

  • RE: Replication Error
    ... account that the SQL Agent runs under. ... When I setup replication two jobs are setup within sql server server. ... step of each job (Snapshot Agent startup message, ...
    (microsoft.public.sqlserver.replication)
  • Re: permission problem?
    ... SQL Agent has an errorlog file, which you for instance can get to from EM, ... I suggest you read in Books Online about permissions. ... >> What error messages do you have in the SQL Server Agent errorlog? ...
    (microsoft.public.sqlserver.server)
  • Re: Exchange 2003 SP3 in deutsch draussen, schon jemand Erfahrungen damit?
    ... der Key hatte aber nicht geholfen ... (z.b. bei meinem SQL Server Backup Problem!). ... >> Alternativ hätte ich noch ein Problem mit der Installation des Agent ...
    (microsoft.public.de.exchange)
  • Re: SQL Server in SBS2000
    ... Some require SQL backend. ... > I would like to setup a database using SQL Server, ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SQL questions
    ... SQL Server can handle this from the database side. ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.sqlserver.server)