Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts with tag Logins Rss

Search for any content tagged logins

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 22    Older >>

Generate Login Script(2008R2 And Older)

Generate Script from Logins of Sql Server to recreate in another instance  Read more...
By Bahram Shayan 2015/08/25 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 1,522 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 2,513 reads

Capture User Auths For Database

This script captures user authorizations by database (default) or by SQL instance   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,517 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2015/09/07 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 4,603 reads


This procedure takes a login name and will generate the access and authorities for the login across the SQL instance.  Read more...
By Donald Patterson 2015/03/02 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 2,788 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2015/10/30 | Source: | Category: secure
Rating: |  Discuss |   Briefcase | 3,108 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: | Category: secure
Rating: |  Discuss |   Briefcase | 1,747 reads

Delete All Database User Accounts for a Given Server Login

Easily and quickly delete all database accounts even if they don't have the same name as server login.  Read more...
By Hakim Ali 2015/05/05 | Source: | Category: user
Rating: |  Discuss |   Briefcase | 2,585 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators 
By Monte Kottman 2015/09/22 | Source: | Category: kpi
Rating: |  Discuss |   Briefcase | 4,265 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,742 reads

Remove Logins Script

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.  Read more...
By Steve Griffith 2012/04/05 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 1,209 reads

Get SQL Server Login Information

The following script is useful to get SQL Server 2005 Login Information e.g., SQL Instance Logins, SQL Logins Server Roles, SQL Logins Database Mapping  Read more...
By Bilal Mahmood 2012/02/27 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 2,514 reads

Audit All Permissions

This script will return all permissions on the server.  Read more...
By Jim Sebastiano 2011/11/16 | Source: | Category: permission
Rating: |  Discuss |   Briefcase | 3,493 reads

Verify SQL Server Login and Login Settings

Verifies that a specified login name exists and has correct settings.  Read more...
By Seth Delconte 2011/07/27 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 1,634 reads

Script Logins

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying. 
By Gordon Klundt 2011/04/04 | Source: | Category: sp_help_revlogin
Rating: |  Discuss |   Briefcase | 2,670 reads

Script DB Level Permissions v3

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 6,670 reads

Script Server Roles

Script Server Roles in case of migration or documentation  Read more...
By Rasmus Glibstrup 2010/08/27 | Source: | Category: migration
Rating: |  Discuss |   Briefcase | 3,098 reads

Fix users for SQL 7 thru 2008

This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.  Read more...
By Mike Tutor 2010/02/19 | Source: | Category: users
Rating: |  Discuss |   Briefcase | 2,144 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: | Category: permissions
Rating: |  Discuss |   Briefcase | 13,591 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,278 reads
   Items 1 to 20 of 22    Older >>