Re: Red X on publication and distribution agent
From: RS (rspen_at_yahoo.com)
Date: 02/20/04
- Next message: Paul Ibison: "3rd party replication tool"
- Previous message: belgiozen: "RE: sp_addscriptexec ERROR"
- In reply to: Shirley Kelly [MS]: "Re: Red X on publication and distribution agent"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 14:47:23 -0600
That helps. I haven't had the problem again, but if I do (and I probably
will), I'll try it.
Thanks,
-RS
"Shirley Kelly [MS]" <skelly@online.microsoft.com> wrote in message
news:G1WTOT49DHA.1988@cpmsftngxa07.phx.gbl...
> 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.
>
- Next message: Paul Ibison: "3rd party replication tool"
- Previous message: belgiozen: "RE: sp_addscriptexec ERROR"
- In reply to: Shirley Kelly [MS]: "Re: Red X on publication and distribution agent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
