Re: **follow "login" activities**

From: BJ Freeman (spam_blockbfree_at_free-man.com)
Date: 06/28/03 

Date: Sat, 28 Jun 2003 09:41:02 -0700

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

  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.programmer)
  • Re: Serious errors with Create view command
    ... the database is opened? ... There's no database on earth that behaves that way! ... What on EARTH does the option of 'Edit Stored procedures' do? ... I can't paste it INTO the view designer sql view ...
    (microsoft.public.fox.helpwanted)
  • Re: Frage zu View-Tabellen
    ... eigenes Element in SQL. ... wenn man prepared statements statt adhoc statements ... Kompilierung entfällt und der Unterschied im Speicherverbrauch besteht darin, ... der Vorteil von Stored Procedures gegenüber prepared statements liegt ...
    (microsoft.public.de.sqlserver)
Quantcast