Re: How to find owner of objects

From: Deborah Bohannon (dbohannon_at_nationalDONOTSENDHEREcareanetwork.com)
Date: 01/15/04 

Date: Thu, 15 Jan 2004 16:10:32 -0600

Can you please tell me why this error would be intermittent? The scheduled
job has run successfully for weeks, and then I get this error. I then ran
the job again and it ran with no problem. I'm thinking if it were truly an
account problem then it would be so every time it is run.

Plus, the server it is running on was never anything besides Windows 2000
Server.

Thanks

"Kevin McDonnell [MSFT]" <kevmc@online.microsoft.com> wrote in message
news:vvkveL72DHA.2588@cpmsftngxa08.phx.gbl...
> The problem you're running into is not actually a SQL issue rather a error
> returning information from the DC.
> See the following kb article;
>
> 241643 PRB: 8198 Error Message Returned from Job Owned by Windows NT
> http://support.microsoft.com/?id=241643
>
> Changing the job ownership to a standard SQL account forces a change in
> code path, which doesn't require a query to the DC.
>
> Each job can be changed to make the job owner someone other than the
> domain\user in Enterprise Manager.
>
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>