Complicated!!!!!!!! Plz provide script

• Nikhil-843675

  SSC Eights!

  Points: 945

  More actions

  February 9, 2009 at 5:06 am

  #199786

  Can any1 help me in generating following output?? Plz provide script..

  I want to collect following details,

  Login_names,ServerLevel role,Database Level role,Databases associated for that role.

  this means i need to capture all login names lets say if there r 3 logins A,B,C then

  i want to capture their names,there server level roles and also details for which databases A is db_owner and for which databases it is dbreader.

  It is too complicated but plz help me out.

• the__t

  Hall of Fame

  Points: 3260

  More actions

  February 9, 2009 at 5:54 am

  #940410

  This is a double-post. Please respond here:

  http://www.sqlservercentral.com/Forums/Topic652712-338-1.aspx

  "Got no time for the jibba jabba!"
  -B.A. Baracus