Post reply

is it possible to identify when, how and by whom the table was deleted in SQL Server 2000

  • September 7, 2010 at 11:27 am

    #226654

    Hi All,

    I have had a query about a table 'disappearing' from SQL Server 2000 named as 'GBLANPS55' in database IMPACT_REP. The table was 'tblRates' and was there on 24/08/2010 but was not there today.

    I have copied a previous version from database 'IMPACT' which I think will suffice "but is it possible to identify when, how and by whom the table was deleted in SQL Server 2000" ?? If yes can anyone please let me know the query or how to check it? Waiting for the answer..

    Have a nice day

    Thanks in Advance,

    Vamshi.

  • September 7, 2010 at 11:39 am

    #1217505

    No. Not unless there was a trace running at the time the table was dropped.

    p.s. Please post SQL 2000 questions in the SQL 2000 forums. Posted in SQL 2008, people will mis-read your post, not notice that you stated a version and give you the SQL 2008 answer.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 7, 2010 at 11:42 am

    #1217507

    Thanks for your reply. Next time I will post the questions as per your suggestion.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply