Home Forums SQL Server 7,2000 General Row are vanished from Table suddenly in SQL 2008 RE: Row are vanished from Table suddenly in SQL 2008

  • July 21, 2014 at 11:00 am

    #1731099

    pratiksawant28 (7/21/2014)

    Currently no other users are using this DB and admin access are with me only.

    While checking have found that the one of the stored procedure was executed for deletion, i have got the last execution but can i found the executor for this procedure???

    Unless that proc does it's own logging, you have a server side trace running, or some other feature (CDC???) running, then no. If someone had dropped the table, it would have shown up in the default trace if no one had turned it off.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)