This script will show you all 'db_owner' members, as well as any logins
that are aliased in the database as 'dbo'.

declare @sql varchar( 100)
select @sql =
'exec ?.dbo.sp_helprolemember db_owner;
exec ?.dbo.sp_helpuser dbo;'

exec sp_msforeachdb @sql



-----Original Message-----
From: Rakesh Upadhyay
[mailto:mssqldba-ezmlmshield-x84458565.[Email address protected]
Sent: Thursday, May 31, 2007 12:49 AM
To: LazyDBA Discussion
Subject: Re: User list with sqladmin and db_owner roles

Use sysusers and syslogin tables in SQL Server 2000

Rakesh
----- Original Message -----
From: "Harpal Singh Sran "
<mssqldba-ezmlmshield-x50111290.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 31, 2007 11:09 AM
Subject: User list with sqladmin and db_owner roles


> Is it possible to get list of users having sqladmin server roles and
also
db_owner database roles in SQL Server 2000?
>
> Thanks
> HSran
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



CONFIDENTIAL AND PROPRIETARY
The contents of this communication are confidential and proprietary to ShopLocal, LLC and may not be reproduced, published or disclosed to others without express authorization of ShopLocal, LLC

Copyright © 2007 ShopLocal, LLC May not be used, copied or distributed without permission. All Rights Reserved.


MS Sql Server LazyDBA home page