Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Santveer Singh List of Database Users with Database Roles RE: List of Database Users with Database Roles

  • January 13, 2005 at 8:50 am

    #537309

    > The MS SP's (it seems) have to be run in each DB separately and the information correlated.

    Use Master

    Go

    Exec master..sp_HelpUser

    Exec pubs..sp_HelpUser

    Exec northwind..sp_HelpUser