Thank you for the heads up and And I agree that service accounts are optimum.

I should have mentioned that I was talking 'development', not 'production'.

I do have a username...

Thanks for your time, I appreciate it.

I solved the problem, see how, at the bottom.

I did run the script (above) and the records returned showed permissions listed as sysadmin. (I...

While 'execute as' is useful at times, it does not work if you are referencing objects in another database.

An easy way is to create the procedure. Test it. Then at...

I tried the script in Instance of SQL 2005. While it is very fast, and I like that, it came back with incorrect information.

1. For a specific user which...

Sounds promising but I seem to be missing something. I have scripts I need to run on all user databases. I've tried using sp_MSforeachDB with "Use DB_ID('?')" and dynamic sql....

My question is at the top. I did solve my immediate connection problem. However, I wanted to know if anyone was able to install a named instance that allowed users...

Actually, that was very good. The two examples they gave, helped me get a visual and a sense of why and how queues are used. All the work I've done...