2021-11-08
430 reads
2021-11-08
430 reads
2021-05-26 (first published: 2021-04-30)
4,462 reads
2018-02-01
860 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
7,773 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)
3,656 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
19,017 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)
11,006 reads
I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?
2009-04-08
4,866 reads
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,886 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Hi guys I have a query with a SELECT statement, that joins 2 other...
Hi all, Can someone please help Pivot a table. The table currently looks like...
Hello Community, Can someone please help transpose a table. The table currently looks like...