Re: **follow "login" activities**

From: Mandar Naik[MSFT] (mandarn_at_online.microsoft.com)
Date: 06/30/03 

Date: Mon, 30 Jun 2003 18:32:21 +0530

SQL Profiler can help you do this.

You can also use some third party tools like Lumigent Explorer which let you
read the contents of a transaction log from where you can get this
information.

http://www.lumigent.com 

--
Regards,
Mandar Naik
This posting is provided AS IS with no warranties, and confers no rights.
"BJ Freeman" <spam_blockbfree@free-man.com> wrote in message
news:OcMLRQZPDHA.1364@TK2MSFTNGP10.phx.gbl...
> look in the Master dB at the stored procedures and extended procedures.
> think you will find some you can use.
> I only have SQL 7.0 so can't help you on specifics.
>
> "M" <mary2001@canada.com> wrote in message
> news:oprrglvwoqhu9goh@msnews.microsoft.com...
> >
> > Hi
> >
> > I've SQL Server 2000,and I login with (for example: "login1","123")
> > and insert 1 record into "table1".
> > Now ,is there any way to find or follow,what did "login1" do?
> > I visited "management-> SQL Server logs" in enterprise manager but there
> > was no subject related to this action.
> > Can anybody help me?
> > Thanks,
>
>

Relevant Pages

  • Truncating Parameters in VS.Net 2003
    ... I have some stored procedures that accept a text parameter ... Right Click on sproc in VS.Net Server Explorer. ... but SQL Profiler shows truncated parameter. ...
    (microsoft.public.vsnet.ide)
  • SQL profiler and index tuning wizard permissions
    ... index tuning wizard. ... however I recently read an article saying that sql profiler can be run by ... I can't find any reference to any kind of stored procedures used by index ...
    (microsoft.public.sqlserver.security)
  • Re: How does OWSSVR.dll call proc_FetchDocForHttpGet stored procedure?
    ... as the stored procedures could be called from other ... In any case, I appreciate your advice! ... So if you want to research the dll internal on how to reach the store procedure, I'd suggest you can use SQL profiler to monitor the SQL ...
    (microsoft.public.sharepoint.portalserver.development)
  • Capturing Stored Procedure, Table and View info with SQL Profiler
    ... I have just started using SQL 2000 SQL profiler to capture server information ... on Stored Procedures. ... I need some help in understanding how to use this tool ...
    (microsoft.public.sqlserver.server)