none
unable to get readonly database logings from sqlserver 2000

    Question

  • I use to get all logings including readonly databases.

    when i am using the following query in the script i am uanble to get readonly fatabase login.

    SELECT sid, name, xstatus, password FROM master..sysxlogins

    please any once suggest me how to script out read only database logins from sqlserver 2000.

    Tuesday, December 11, 2012 6:31 AM

Answers

  • hello, logins is on Instance level not on the database level- so you can use either sp_helplogins to get all the logins informations on Master database-


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, December 11, 2012 3:22 PM

All replies

  • hello, logins is on Instance level not on the database level- so you can use either sp_helplogins to get all the logins informations on Master database-


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, December 11, 2012 3:22 PM
  • I Agree with Uday. What is it with readonly database and logins. Logins are something that is on Instance level and has nothing to do with Database state.

    Sp_helplogins would give you all the login info.

    Thanks and Regards

    Santhu

    Thursday, December 13, 2012 8:21 AM