Preventing delete

  • Hello, everyone.

    We have a very interesting problem. Fortunately, this was happened with test database. We lost information from one of the tables. There are some developers who worked with this table.

    How can we define what happend?

    Database backed up once a week, and transaction log every hour?

    Thanks in advance.

  • Use a Trigger instead of delete in a table

    and rollback or other things

  • When managing permissions for the table, do not grant delete. Grant permissions to stored procedures that do any necessary deleting.

  • I think what you are asking is, Is there a way to see how this occured?  It is possible to view the transaction log file and view the transactions by using Log Viewers like Lumigent.  Beware though!  These products are VERY expensive.

    The best thing to do is to recreate and trace the activity with SQL Profiler.

    Hope that helps.

    steve

  • Thank you. Yesterday we did these.

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

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