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.

Answer 1

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.

Answer 2

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