UPDATE

I got this to work on a test box. We removed the account from a bunch of group policies and then I changed the proxy account using EM. ...

I posted this question in the SQL Server Agent forum and that is where the discussion has been going on. If you have any other input, please go to...

epay0,

I had already reviewed that article and it applies to SQL 7.0.

Thanks anyway.

I think we may be close to solving this problem. The problem seems to be with the...

Yes, I am trying to make them all the same account. I have not seen anything that says this will not work.

Also, I tried using my own login as...

It's not an NT user right problem. I logged into the server with the account that I am trying to make my proxy account. Also, the message comes...

Microsoft SQL Server 2000 - 8.00.679 (Intel X86) Aug 26 2002 15:09:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build...

I get the same error there, too.

It is already part of the local Administrators group and I have checked all of the rights it has on the server. Everything looks good.

Yes. This account is part of the sysadmin server role.

Duh, never mind, I found it. In my real code I had another error that I couldn't get past to see the problem with the code I sent here.

Thanks...

Never mind, I got it. I simply scheduled the package and it created the job. Then I just added my stored procedure steps around the step it had...

Political Correctness is my Pet Peeve!

32 (33 in Jan), 3 kids (5 yr old girl, 2 yr old boy, & 8 week old girl)

Married to the most wonderful woman in the world. (She'd have...

Ray,

I've heard SQL Server 2004 is expected out in 3rd or 4th quarter of 2004.

Have you heard anything about when they will start selling SQL Server 2004 licenses?

I...

I was looking for a pure TSQL solution.

I've ended up using the sp_helpfile idea. (Thanks Allen_Cui.)

I just finished running a test with this code in...