Query Active Directory to Display Login Information

Query Active Directory to get information on user logins.

Show SQL authentication login information

View login information for all accounts that use SQL authentication.

Login Properties

Create Database User

This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.

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?