Script to find username and corresponding loginname for all user database in SQL Server  Read more...

Changes DB owner to sa for Online DB's where owner is not sa  Read more...

This script gives a server level snapshot of recent security changes  Read more...

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.  Read more...

This script will return all permissions on the server.  Read more...

list each user has the right to do  Read more...

Query Active Directory to get information on user logins.  Read more...

View login information for all accounts that use SQL authentication.   Read more...

Run the output of the following script in master database to drop common user in all the application databases  Read more...

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.   Read more...

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

Script to grant exec permission to all sps in a db  Read more...

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

How to create a database snapshots dynamically  Read more...

A script to reveal which logins have access to your sql server via windows groups.   Read more...

This is best run through SSMS 2008 against multiple server. When done so, it will display the port number that SQL is listening on.   Read more...

Restrict Access to SQL by HostName, IP, Application Name, etc...  Read more...

Use this script to search for SQL Server logins who use weak password  Read more...

The script returns all orphaned database users across a SQL Server.  Read more...

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...