Viewing 15 posts - 1 through 15 (of 34 total)
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...
January 17, 2019 at 10:11 am
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...
January 16, 2019 at 6:44 am
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...
January 15, 2019 at 11:19 am
Ah...never mind. I see now the replies. Thanks!
May 22, 2015 at 6:02 am
Are we talking about two different things in this thread?
Grant Execute on <proc> to <user> as dbo
Create Proc <procname>
WITH Execute AS <dbo>
Are you saying that the first...
May 22, 2015 at 5:56 am
That's sounds like a great plan, Nevyn. Until they figure out you're not one of the, "can't live without" employees. 🙂
December 31, 2013 at 12:18 pm
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...
December 30, 2013 at 1:32 pm
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!
October 23, 2013 at 7:49 pm
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...
March 13, 2013 at 2:24 pm
Great!! Thanks All!!
March 13, 2013 at 2:09 pm
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...
March 13, 2013 at 1:49 pm
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...
July 31, 2012 at 9:10 am
@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...
July 31, 2012 at 8:07 am
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...
November 4, 2011 at 6:43 am
Thank you very much.
August 30, 2011 at 7:26 am