2024-02-05
380 reads
2024-02-05
380 reads
2022-08-15
352 reads
2021-11-08
440 reads
2021-05-26 (first published: 2021-04-30)
8,154 reads
2018-02-01
865 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
10,122 reads
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)
6,094 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
23,118 reads
Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
2012-03-29
4,423 reads
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
15,021 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers