Find Deny permissions on database objects
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
2,704 reads
Captain DBA
Blogs
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get...
Forums
Seeking input on Best Method to Join on First or Last Row in a 1:M Join
I have included the DDL to re-create the 2 tables in this examples. I...
DB logins permission script out
Hi, Can anyone share or point me to get -DB logins permissions in a...
UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue
I've been working a little bit with a few tables here, they've got "CreatedDate"...
Ask SSC