Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Friday, November 1, 2013 7:39 AM



Group: General Forum Members
Last Login: Monday, November 28, 2016 1:29 PM
Points: 145, Visits: 341
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
( - 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 (513 views, 4.14 KB)
Post #1510590
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse