Post reply

finding out users or login who has committed wrong data

  • February 19, 2013 at 10:24 am

    #270993

    Well the question is ,if in the production server there is no setup of audits or ddl trigger not even profiler running.how would one find out if some user has

    wrongly updated a table .what is the way to find out who performed this action and when, in sql 2008?

  • February 19, 2013 at 10:42 am

    #1589299

    I don't believe this is possible unless you already have Change Data Capture running

    There is nice app from ApexSQL which can be used as a trial and literally and visually you can see all the data within SQL Server Transaction Log file(s).

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • February 19, 2013 at 10:44 am

    #1589301

    MyDoggieJessie (2/19/2013)

    I don't believe this is possible unless you already have Change Data Capture running

    There is nice app from ApexSQL which can be used as a trial and literally and visually you can see all the data within SQL Server Transaction Log file(s).

    True, but the log doesn't keep the user who did it, right? you can only find out when something happened and at what time, i think, but no whodunnit info is part of the log, i think.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 19, 2013 at 10:49 am

    #1589305

    I believe that's correct. But depending on how long ago it happened the statements used might still be in the sys.dm_exec_query_stats DMV?

    EDIT: I meant the sys.dm_exec_sql_text DMV

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • February 19, 2013 at 10:53 am

    #1589307

    Scratch that, I guess there's no real way to tie the statement back to a user :crazy:

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 5 posts - 1 through 4 (of 4 total)

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