2024-02-05
391 reads
2024-02-05
391 reads
2022-08-15
355 reads
2021-11-08
444 reads
2021-05-26 (first published: 2021-04-30)
8,559 reads
2018-02-01
870 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
10,923 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,562 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
23,844 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,638 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Comments posted to this topic are about the item Is Ransomware Fading?
Comments posted to this topic are about the item How to Resolve SQL Server...
Comments posted to this topic are about the item A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers