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 |
|
indyandumi
Starting Member
6 Posts |
 Posted - 2007-01-20 : 20:26:04
|
| I am trying to get list of users on different dbs located on different servers.Currently i get them manualy by going on each db and copy the users to excel sheet.I tried to use sysusers, but i needed status of their account, created . Is there any easy way where i can pull list of users from all dbs from at once.Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-20 : 22:58:09
|
[code]exec sp_MSforeachdb 'use ? select dbname = db_name(), name, createdate, updatedate from sysusers'[/code]
KH |
 |
|
|
|
|
|
List of all users in Different DBs