Why should it error out? does the table not exist?

You don't shrink the log for performance. You might want to read this article: http://www.sqlservercentral.com/articles/64582/

You'll have to do some work. I might start here:

http://msdn.microsoft.com/en-us/library/aa214450%28SQL.80%29.aspx

I've typically just had a holiday table since each business handles them differently. It will allow you to easily query for any off days, as Jeff mentioned, that are specific...

If you want to roll your own, you'll need to make multiple passes through the table to clean things up (potentially). You'll need to set rules for how you handle...

SETUSER was my first thought. If it's SQL related, then that covers tracks.

However since so many people use the same pwd on other systems, getting the hash from SQL and...

:-), had to thank Allen publicly for responding to my query.

All I can add it "Allen is the man!"

That's strange. Are you sure that the rights cover those files? Perhaps there's something weird with them?

Can you log in as the domain user running the Agent?

The user must not have rights. Access denied is a simple message. Do you have a domain user running the Agent? Can you log in as this user and execute...

I pinged my resident PS expert with this thread, so hopefully Mr. White will respond.

I'd agree that you need two roles.

Create a role in each db, then assign the permissions needed with the GRANT statement. If you don't grant rights, as in control of...

Are there connections open by any chance?

Linked servers?

http://msdn.microsoft.com/en-us/library/cc281962.aspx

The issue, in my mind, is that even if this is fixed, a rouge administrator can use tools to crack these password hashes relatively easily and impersonate someone. So this...