Re: SQL SERVER 2000: obtain user list

Ok, thanks but I don't understand what to use SQL PROFILER to obtain
the complete list of the user's permission...
Are you sure?

Steve ha scritto:

diaboliko80@xxxxxxxxx wrote:
Hi,
I would like extract in a document (.doc, .txt, .cvs, .xml or also) the
complete list of all user that logins to my SqlServer 2000.... that is
I need to know for each user to which databases accedes.

For example, the user TOM WHITE accedes to the database [SCHOOL],
[NEWS] and [JOB] with read/write permissions. I would like extract
these informations for all user and prints in a file to obtain a
complete documentation dinamically.

It's possible in SqlServer2000?
Thanks,
Luigi.

PS: sorry, but I don't write English very well.. :_(
The tool in SQL Server is Profiler.
See the Books Online topic "Introducing SQL Server Profiler "
or on the web http://msdn2.microsoft.com/en-us/library/ms181091.aspx

.

Relevant Pages

  • Re: Sql 2005 Profiler
    ... Jasper Smith (SQL Server MVP) ... the server reported both duration and CPU ... I'm using a trc file to do the load testing through profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler
    ... > ich verwende SQL Server 2000. ... > die mir mit SET STATISTICS ON; ... > Ich habe im SQL Profiler unter "Leistung" Execution Plan, ...
    (microsoft.public.de.sqlserver)
  • Re: Sql 2005 Profiler
    ... In SQL Server 2000, the server reported both duration and CPU time ... I'm using a trc file to do the load testing through profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: Clueless in 80040e31 land
    ... Locks event in Profiler to see if this is the case. ... Using SQL Profiler was no help. ... single quote, or something that is difficult to catch, but after many ... You should turn on NOCOUNT to avoid sql server sending informational ...
    (microsoft.public.inetserver.asp.general)
  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... Stats being compiled on SQL Server ... If you are dynamically adding statements in a sproc, ... compare this to the profiler command (meaning what is actually run in the ... Duration: 440 ...
    (microsoft.public.dotnet.framework.adonet)
Loading