Re: **follow "login" activities**

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 06/28/03 

Date: Sat, 28 Jun 2003 08:31:41 +0200

Mary,

Use the SQL Profiler. Check the "Monitoring with SQL Profiler" part in Books
OnLine
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ad
minsql.chm::/ad_mon_perf_86ib.htm). 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"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

  • Re: dbo qualified name error w Access 2003
    ... correctly, things ended up being owned by dbo, which is *not* ... One tool you should use is SQL Profiler. ... to see the calls between Access and SQL Server, ... >When I use an adp from Access 2000, this code executes successfully for all ...
    (microsoft.public.sqlserver.msde)
  • Re: Change Admin PSW...
    ... Control Panel - Services). ... FAQ from Neil & others at: http://www.sqlserverfaq.com ... for SQL Server professionals - http://www.sqlpass.org ...
    (microsoft.public.sqlserver.security)
  • Re: Locking ASP.NET Session State with SQL Server
    ... SQL Server session state is retrieving and saving varbinary/image ... Go watch it work with SQL Profiler turned on. ... It seems that the sql server solutions is not very scalable or reliable. ... > because all pooled connections were in use and max pool size was> reached. ...
    (microsoft.public.dotnet.framework.performance)
  • RE: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user NT A
    ... Server is 2000, you can open Enterprise Manager, expand your SQL Server ... Also since "NT AUTHORITY\SYSTEM" is a service account, ... you can run SQL Profiler to monitor your SQL Server instance and add ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user NT A
    ... Server is 2000, you can open Enterprise Manager, expand your SQL Server ... Login..., and then add the Windows login "NT AUTHORITY\SYSTEM". ... you can run SQL Profiler to monitor your SQL Server instance and add ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)