Thanks to all for the replies.

Thanks Eddie,
I've tried to use Execute As Login.
I'm able to start the Execute As Logon, however, I'm not sure if it's...

Summary:
I'm trying to automate a process. 
In the process I create sql credentials and a windows account.
At a point in the process I have to execute code...

Thanks for the reply, Jeff.  This is just a simulation where I'm using a dummy account on a test server and was tired of typing the pwd.  I can't imagine...

Ah...never mind. I see now the replies. Thanks!

Hi Steve,

Are we talking about two different things in this thread?

Example 1:

Grant Execute on <proc> to <user> as dbo

and

Example 2:

Create Proc <procname>

WITH Execute AS <dbo>

AS

<.........>

Are you saying that the first...

That's sounds like a great plan, Nevyn. Until they figure out you're not one of the, "can't live without" employees. 🙂

Not a good idea...IMO

"Most" people want to know they have a place in the company. If people are paid well for what they do and are excited to go...

Steve,

How many times have you ever heard anyone lying on their death-bed speak the words, "I wish I would've worked more."

I'm guessing none.

Have a good time!

Mark Cusano

That is exactly what I would like to accomplish....performance data into a DBA database table.

I've established a fantastic DBA database using Powershell and the performance tables is the one thing...

Great!! Thanks All!!

Thank you all for the replies! Very much appreciated.

I ran the following script against a database that's having performance problems. The script returns about 400 deadlock records dating...

I have been wanting to create a nice clean package to post, but we're in the middle of a major project and haven't had any time to come up for...

@cusanom I've written @PowerShell scripts to inventory our entire network of sql servers on a scheduled basis and dump everything into a single database. I was hated...

Thanks Jeremy. I've already tried this one twice, but it doesn't seem to work. Blows my mind that a uninstall can become this complicated. I'm going to...

Thank you very much.

-Mark