Viewing 15 posts - 1,816 through 1,830 (of 9,720 total)
Steve Jones - SSC Editor (4/26/2016)
Good catch, Brandie.
I hate anyone that adds any permissions to public. Please, please,...
April 26, 2016 at 11:42 am
Jacob Wilkins (4/26/2016)
That DENY didn't show up in the results of the query I posted earlier?It should have, so I'm curious why it didn't.
Cheers!
No, it did not, actually. Weird...
April 26, 2016 at 11:40 am
yb751 (4/26/2016)
Speaking of Kylo throwing a tantrum...
Best Kylo Ren Twitter account ever.
April 26, 2016 at 11:34 am
Lynn Pettis (4/26/2016)
Brandie Tarvin (4/26/2016)
Seriously. SERIOUSLY?
Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this...
April 26, 2016 at 11:04 am
Lynn Pettis (4/26/2016)
Can you recreate the issue with a sandbox database in a test/development environment?
This is our test environment. We're testing the vendor move to SQL 2012 before moving it...
April 26, 2016 at 11:02 am
[headdesk]
Seriously. SERIOUSLY?
Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this link.
SELECT b.name, CASE a.protecttype...
April 26, 2016 at 11:01 am
Hrmpf.
Nope. Doesn't fix it. Still with the permission error on BACKUP DATABASE. And the backup command works. I've printed it out to the job log and run it myself. So...
April 26, 2016 at 10:52 am
Lynn Pettis (4/26/2016)
If you will assign user as db_backupoperator you will discover error when you will try to create a backup..
When trying to specify location, you...
April 26, 2016 at 10:47 am
Steve Jones - SSC Editor (4/26/2016)
Loguser_name()
suser_sname()
etc. (there are a few more)
into a table before the app runs the command (and the command). Check there isn't any impersonation.
We...
April 26, 2016 at 10:33 am
There were no deny perms initially. I double-checked, there are none now.
Any other ideas?
April 26, 2016 at 7:54 am
Oh, here's two in German that I learned from a coworker when I was in high school.
Er/Sie hat nicht alle tasse im Shrank.
and
Du hast ein Vogel.
Roughly translated as "He/She doesn't...
April 25, 2016 at 7:42 am
J Livingston SQL (4/25/2016)
BWFC (4/25/2016)
Luis Cazares (4/25/2016)
Ed Wagner (4/25/2016)
Jeff Moden (4/24/2016)
TomThomson (4/22/2016)
Phil Parkin (4/22/2016)
Eirikur Eiriksson (4/22/2016)
Brandie Tarvin (4/22/2016)
April 25, 2016 at 7:24 am
frederico_fonseca (4/22/2016)
April 25, 2016 at 5:41 am
In this case I did add my two cents because I've seen that damn failure before and it took me days to figure out what the issue was the first...
April 22, 2016 at 12:39 pm
Viewing 15 posts - 1,816 through 1,830 (of 9,720 total)