List all Usernames, Roles for all the databases.

• shivaram challa

  SSCrazy

  Points: 2415

  More actions

  November 1, 2013 at 7:39 am

  #1663413

  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[/url]