First, yes, the account has delegation rights.

Second, I wanted to provide an update that I finally found the solution this morning.  The issue was the browser.  This particular server only...

I can't find a way to delete this post so I just want to supply an update.  The EXECUTE on the stored procedures worked just fine.  The issue was in...

OK, I was finally able to make the change and make this user part of the db_owner role.  It took this long because I had to wait for our scheduled...

Sorry I am just now getting back to responding.

I have played with the timeouts and let it run a long time.  I decided to try it again this morning and...

Thanks for responding and at least letting me know I haven't lost my mind about not being able to find anything.  The strange thing is, these instances are default instances...

Please excuse my delay in responding and my somewhat incomplete description of the situation.  I put this post together rather hastily and did not do a good job of proofreading.

Thank you Jacob, I definitely got tunnel vision on this one.  I am aware of what you are talking about and, now that you say it, it makes perfect sense. ...

Restoring the system databases wouldn't help reset any settings within the user database being restored.  The purpose of this script is to re-apply users, database roles, and role memberships after...

Sean Lange, no worries!  I don't take any offense at a good conversation on here.  We're all here to learn, no matter how long we've been doing this.  Actually, the...

gvoshol 73146, the script has now been updated to include the schema in the output.

Sean Lange, I have heard about some problems with this undocumented procedure but I...

Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do with UAC settings on...

Sorry that I'm a little late to the party but this was an excellent article to help me get this monitoring setup in our environment. It has already helped...

I just wanted to follow-up with what happened with this issue.

After nearly bringing the system to its knees by running Profiler traces to find ALL of the locking, and other...