Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag users Rss

Search for any content tagged users

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 9 of 9   

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: | Category: login
Rating: |  Discuss |   Briefcase | 986 reads

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 905 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,572 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,781 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,161 reads

Database Users And Associated Database Roles

This script basically retreives all database users thier database roles for a database.   Read more...
By Larry Sumuri 2010/02/10 | Source: | Category: users
Rating: |  Discuss |   Briefcase | 3,372 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 4,098 reads

Terminate All User Processes Without Stored Procedure in SQL Server

This script kill all connections on the specified database without stored procedure.  Read more...
By andre.brunaldi 2008/09/10 | Source: | Category: kill
Rating: |  Discuss |   Briefcase | 254 reads

show users in NT Groups

List users in NT Groups 
By Mani Singh 2008/07/29 | Source: | Category: administrator
Rating: |  Discuss |   Briefcase | 1,219 reads
   Items 1 to 9 of 9