Script Application Roles

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 19, 2009 at 7:51 am

  #131083

  Hi,

  I need to script out database and application roles for databases on one of my server. Can someone provide any such script or tell me whish field stores the password for application role in a database?

  I need this for server upgrade backup process.

  MJ

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  February 20, 2009 at 1:15 am

  #947343

  MANU (2/19/2009)

  ---

  Hi,

  I need to script out database and application roles for databases on one of my server. Can someone provide any such script or tell me whish field stores the password for application role in a database?

  I need this for server upgrade backup process.

  MJ

  u can use sqldmo thru vbscript to script out database roles...give it a search ...

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]