Running SSMS after AD account is disabled

Security Audit Db_DataReader

Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.

How to check SQL Server Authentication Mode using T-SQL and SSMS

Many times developers want to put logic into their code or SSIS/DTS package to check the SQL Server authentication mode. How can this be done programmatically?

Script to grant exec permission to all sps in a db

Script to grant exec permission to all sps in a db

Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?

Implicit Permissions Due to SQL Server Database Roles

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?

Script DB Level Permissions v3

Scripts role membership, object-level permissions for all DB users.

Extended Protection available in SQL Server 2008 R2

We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications. What other security methods can we employ with SQL Server?

Restricting SecurityAdmin on SQL Server 2005/2008

Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.