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 | 986 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,486 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,504 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 2013/11/12 | Source: | Category: logins
Rating: |  Discuss |   Briefcase | 3,295 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,767 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 2013/11/04 | Source: | Category: secure
Rating: |  Discuss |   Briefcase | 2,154 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,544 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,469 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators 
By Monte Kottman 2012/11/09 | Source: | Category: kpi
Rating: |  Discuss |   Briefcase | 2,829 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,722 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,207 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,497 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,422 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,622 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,665 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,131 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,080 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,138 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,369 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,276 reads
   Items 1 to 20 of 22    Older >>