sql 2000 tracker

Posted on 2006-04-27
Last Modified: 2010-07-27
Hi all,
I had a problem where some one deleted a table and I don't know how to track it. do you all know any way or software that will track a clients system and show who and what they were doing in there and time and date?  I'm clueless. thanks
Question by:cdb424ttm
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    You can make use of some log viewers,I suggest you go for Lumigent Log Explorer, You can also do it using Apex Log
    LVL 75

    Accepted Solution

    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    You can use the following undocumented command in this case:

    DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )



       Dbid or dbname - Enter either the dbid or the name of the database
                        in question.

          type - is the type of output:

          0 - minimum information (operation, context, transaction id)

          1 - more information (plus flags, tags, row length)

          2 - very detailed information (plus object name, index name,
              page id, slot id)

          3 - full information about each operation

          4 - full information about each operation plus hexadecimal dump
              of the current transaction log's row.

    by default type = 0


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now