Login Fixed Server & Database Roles

• Bhushan Kalla

  Default port

  Points: 1475

  More actions

  February 14, 2007 at 8:08 am

  #92969

   

  How to find what are the existing logins in the SQL Server instance and also how to find what fixed server and database roles are to the logins in an sql server instance? I have 35 SQL servers in my environment and need to prepare spreadsheet for login and their fixed server and database roles information. Any help is greatly apprecciated.

  Thanks,

  BK

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  February 14, 2007 at 10:20 am

  #689762

  Please don't cross post.

  Answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=344818