Script Application Roles

  • 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

  • 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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply