diaboliko80@gmail.com 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.. :_(

> diaboliko80@gmail.com 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