Last deleted record

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tejasri p
    New Member
    • Jul 2011
    • 1
    #1

    Last deleted record

    I have a table in which columns are yearid,Quarteri d,CreatedDate.N ow the problem is i want to get the last deleted record from this table?
    Can anyone help me out in this?


    Thanks in Advance....
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      You'll have to talk to your dba and hopefully they have a backup or it's been logged and it's still there. It will depend on what recovery model is running on the server.

        Comment

        • ck9663
          Recognized Expert Specialist
          • Jun 2007
          • 2878
          #3
          Are you asking about the last row of record? If someone deleted three record, do you need the very last one?

          I'm not sure you can identify the very last record. But you can identify which records were deleted by creating a trigger on the table you are trying to monitor.

          Good Luck!!!


          ~~ CK

            Comment

            Previous template Next
            Working...