Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567

List all Usernames, Roles for all the databases. Expand / Collapse
Author
Message
Posted Friday, November 01, 2013 7:39 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 01, 2013 7:40 AM
Points: 145, Visits: 336
Hi All,
The script is updated to get the integer value of the major version number; instead of comparing the varchar values. also, this script will work for all the future versions of SQL Servers until there is paradigm shift in how SQL Server stores this information. Please let me if you have any problems using the script.


Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help


  Post Attachments 
list all Usernames, Roles for all the databases_v4.txt (232 views, 4.14 KB)
Post #1510590
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse