Viewing 15 posts - 46 through 60 (of 337 total)
Ok I dug into the BOL a little bit and read more about Database mail.... looks like that's the way to go.
January 13, 2012 at 8:05 am
Shawn,
Thanks for the help on this. I can't change how the application works so I can't rewrite that "Alter Login" command. For now if I want to change passwords within...
May 23, 2011 at 9:46 am
Ninja,
Yeah I normally do it like that but I just stumbled across this and decided to waste everyone's time posting I guess.
But decided to run a quick test after you...
May 23, 2011 at 7:47 am
I was just trying to capture a result if there was data present. If I use @@Rowcount I usually do it like this:
select ID from tTable Where....
SET @RowCount = @@RowCount....
What...
May 23, 2011 at 6:08 am
Greg,
That's actually a great idea and an easy way to do it. I've done plenty of concatenation just like the select statement in your function but I just didn't think...
May 6, 2011 at 11:01 am
Yeah for now it is. I'm not so much concerned with the current way it's being stored but just extracting the data so we can import it into another system.
May 2, 2011 at 2:38 pm
That's exactly what I'm trying to avoid. This is a third party application in which they grant all users SysAdmin access. I'm trying to lock them down so they have...
April 4, 2011 at 6:23 am
Yes that worked. I had the wrong command. Not sure what the other command did.
Thank you for the reply and solving my issue. Thanks again!
April 1, 2011 at 2:49 pm
Okay I think I did try that. Is the command this:
GRANT CONTROL ON LOGIN:: [User1] TO [User2]
Yeah even if I do apply that I still can't reset the password.
USE...
April 1, 2011 at 2:23 pm
Ok I've been digging into this a little more. I guess there is a difference from changing passwords and password resets. If I change a password without providing the old...
April 1, 2011 at 1:58 pm
Found the answer.
You have two options:
1. GRANT VIEW ANY DEFINITION (not recommended)
2. GRANT VIEW DEFINITION ON LOGIN::User1 TO User2
User1 will be the user you want to view the metadata of...
March 31, 2011 at 9:53 am
It's not that it's not accessible. The issue is if you run the below command under the context of a user that only has public permissions you will not retrieve...
March 30, 2011 at 1:00 pm
Yes it is.
This app has users access data or update data on the master and msdb table. What I want to do is create a Database role under the...
March 30, 2011 at 9:38 am
I found the problem to the login issue. That user was denied permission to connect to the DB. However if they are part of the ServerAdmin role it overrides that...
March 30, 2011 at 8:03 am
runaldo,
Thanks for the suggestion.
Yes I have the passwords but the application encrypts the passwords so I actually have to go into SQL to change that password if I want to...
March 30, 2011 at 7:39 am
Viewing 15 posts - 46 through 60 (of 337 total)