Captain DBA

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.5 (2)

2015-01-14 (first published: 2014-12-17)

3,500 reads

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

I am thrilled to have been a part of this year’s Storage Field Day...

Hello, I was looking over the Edition specifications, and Standard is capped at 128...

A client of ours is upgrading their database to SQL Server 2019. The edition...

Hi, I need to perform backup and save it in network drive. I have...