SQLServerCentral.com Scripts tagged Logins

Top 14 KPI

Fri, 09 Nov 2012 07:00:00 UT

Get the 14 most used Key Performance Indicators

Login Password Policy

Tue, 24 Apr 2012 06:00:00 UT

This script lists all of the SQL logins with their password policy

Remove Logins Script

Thu, 05 Apr 2012 06:00:00 UT

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

Script Logins

Mon, 04 Apr 2011 06:00:00 UT

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.

Script DB Level Permissions v2.1

Wed, 02 Feb 2011 07:00:00 UT

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

Fix users for SQL 7 thru 2008

Fri, 19 Feb 2010 07:00:00 UT

This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.

Logins created in the last X Days

Fri, 23 Dec 2011 07:00:00 UT

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Audit SQL Logins - Updated

Mon, 23 May 2011 06:00:00 UT

SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now