Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ryandavebrigino@yahoo.com
Starting Member
9 Posts |
 Posted - 2008-08-27 : 03:37:44
|
| Good day everyone,I was assigned to provide a list of Login accounts from SQL Server 2000 and 2005. currently, I am doing this on SQLServer2005 by opening the security folder and manually opening each accounts from the Login folder. but this method consume alot of time. and i have to provide this list from 18 DB Servers.I once heard that information about the SQL login accounts are saved in the systems databases, but i dont know which system databases and tables houses the Login accounts.if anyone has done this listing before. please give me some info to find the Login accounts. so i can provide a T-SQL that will return this columns. Login Name, User Mapping DB, Server Role, DB Rolethanks guys. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 03:51:44
|
| select * from sys.syslogins where isntname=0 |
 |
|
|
ryandavebrigino@yahoo.com
Starting Member
9 Posts |
Posted - 2008-08-27 : 04:06:39
|
| thanks visakh16, this queryselect * from sys.syslogins where isntname=0works. now i'll just filter the columns for my desired results.this works for SQL Server 2005 but not on 20002000 do not have sys.syslogins table.thanks. |
|
|
|
joe.inom
Starting Member
9 Posts |
Posted - 2008-08-27 : 04:18:45
|
| Now i have heard a lot about it , but i havent done listings before.Now it is like the system database and tables are the stuffs you create , and then you link the Login profile with it , it is like you have to create seperate directories for each.San Diego Home Insurance |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 04:24:40
|
| if 2000 use select * from syslogins where isntname=0 |
|
|
|
|
|
|
Select SQL Login accounts