Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Application Roles Expand / Collapse
Author
Message
Posted Thursday, February 19, 2009 7:51 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
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

Post #660336
Posted Friday, February 20, 2009 1:15 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Sunday, September 28, 2014 10:35 AM
Points: 1,475, Visits: 1,634
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,
Sqlfrenzy

Post #661101
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse