Re: 50 and more servers, 200 and more datyabases, HOW TO list USER

Tech-Archive recommends: Fix windows errors by optimizing your registry

Am Mon, 5 Jun 2006 09:03:02 -0700 schrieb Eric DonBanziani:

If i use Query Analyzer, should i open each DATABASE manually ?

I haven't find how to make this magic script:

-Connect each server
-connect each database
-extract each database user

Thanks.


"Keith Kratochvil" wrote:

Have you used Query Analyzer? You may find that it is much more simple to
use (not to mention, faster) for many tasks.

--
Keith Kratochvil


"Eric DonBanziani" <Eric DonBanziani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4FAE9B0D-07F3-458C-89D5-8183CF4ECE26@xxxxxxxxxxxxxxxx
Hi everybody,

I have more than 50 servers. Each server have 1 to 20 or more databases.
All
databases are SQL SERVER 2000 SP3 / SP4.
Does anyone knows a script or a tool to list each DATABASE users ?

It's borrying to use Enterprise Manager, connect each server, each
database,
and export user list...

Thanks for your help....




For the servers i dont know how to do this automatic with a sql statement,
but for the databases on a server there are so magic (and in BOL not
documented) functions like sp_msforeachdb ... :
http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm

bye, Helmut
.

Relevant Pages

  • Re: Creating and using a database VC++ 2005 and using WMPlayer Act
    ... "Keith Kratochvil" wrote: ... Why do you think that you need to use a database? ... probably require a web server of some sort. ... via a fat client application. ...
    (microsoft.public.sqlserver.clients)
  • Re: SecurityAdmin server role
    ... Add that login to that partcular database as a database user and assign ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Moving ALL DBs to new server
    ... I've just recently had to move my database to other server. ... The faster way to move and get them running was stopping sql services copy ... > Keith Kratochvil wrote: ...
    (microsoft.public.sqlserver.server)
  • Permission
    ... I have a database user in my SQL-server (a server I use for test and ... This user has some select and update permissions on some ... Is it possible to make a script or anything else so that the database ...
    (microsoft.public.sqlserver.security)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)