Thanks that is what I thought!

Thank you all for your help!

Ken

Thank you both for your input!

David

You are absolutly correct! Got to stay nimble.

Thanks for your insight

Ken

If you are still looking for a good admin book, the best I found is SQL Server 2000 DBA Survival Guide by Spenik and Sledge, I also have the book admin 911 SQL...

I don't have any direct experience with this and I have a friend who wants to do the same thing. I suggested to her that perhaps she could use DTS?...

We are at SP 3a

Thank you for your help!

I think I have solved the problem but not sure just which fix did the trick. We added the account for the SQL Agent to the local administrator group, gave...

I want to thank you all for all your help and suggestions. I have had to put this issue on hold as something else has come up. I will revisit...

Thanks Jonathan, that did the trick!

Ken

Thanks Markus for the suggestion..

Carl

Yes that will do the trick. Thanks!

Ken

I am an Oracle DBA working for a city goverment and I make about $58K. I also server as the SQL Server DBA, now my CIO seems to think there...

I agree 100%, I will be forwarding this tip to one of my co workers who encoutered the very problem the article speaks to!