2018-02-01
857 reads
2018-02-01
857 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
5,837 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)
2,450 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
14,651 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)
8,210 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,837 reads
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Using mode() in R
We are running SQL Server 2017 (RTM) on Windows. The question came up, if...
I'm having an issue with a database that I recently moved from SQL 2014...