Re: Red X on publication and distribution agent

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Shirley Kelly [MS] (skelly_at_online.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 07:40:18 GMT

Hi RS,

There is a table in the tempdb database that contains the status of the
agents. If the status is incorrectly displayed, there are two options to
resolve the issue:
    1. Restart SQL Server. Tempdb is recreated whenever SQL Server
starts, so this cleans up the incorrect status.
    2. Manually delete the row with the incorrect status. Because this
involved modifying a system table, I won't tell you exactly which table it
is, but I think you'll be able to figure it out by looking at the tables in
the tempdb database :-)

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Relevant Pages

  • Re: Red X on publication and distribution agent
    ... > There is a table in the tempdb database that contains the status of the ... Tempdb is recreated whenever SQL Server ... Manually delete the row with the incorrect status. ...
    (microsoft.public.sqlserver.replication)
  • Re: use of tempdb by union all
    ... It was my impression that the tempdb database will be used when SQL Server ... the section "tempdb and Index Creation" in the SQL Server 2000 ... I think it might be misleading to imply that the tempdb database area is the ...
    (microsoft.public.sqlserver.programming)
  • Re: use of tempdb by union all
    ... SQL Server will indeed allocate "scratch space" from the user database, ... >> It was my impression that the tempdb database will be used when SQL ...
    (microsoft.public.sqlserver.programming)
  • RE: Transactional Replication Setup
    ... If either of these is incorrect, ... You'll have to restart the SQL Server service for ... SQL Server Support ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.replication)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... fix of 1*value and it works as you mentioned. ... To answer your question about copying between SQL Server instances I don't ... will copy between SQL Server tables carrying with it the incorrect sign bit. ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)