Posted by Alex Kuznetsov on 06/20/07 19:59

On Jun 20, 2:53 pm, "Neil" <nos...@nospam.net> wrote:
> We are running SQL 7 with a front end that links to the tables through ODBC.
> In our main table, the user has no way to delete a record through the
> interface, though it is possible to delete it by opening the ODBC link.
> Users would have no reason to delete a record, but one of our records turned
> up missing.
>
> Now, it's possible that a user may have accidentally deleted the record.
> But, since users don't have any reason to delete records, and since they
> don't access the ODBC links, it seems unlikely (though possible).
>
> I was wondering if anyone had every heard of SQL Server ever "losing" a
> record that had previously been saved. I checked the nightly backup from the
> night after it was added, and the record was there. So either a user deleted
> it, or somehow it got lost in SQL Server. I have no code that deletes
> records in this table in any way, shape or form, so it couldn't have been
> malfunctioning code.
>
> So, while I have a hard time believing that SQL Server would just "lose" a
> record, I also know that anything's possible, so I thought I'd ask if anyone
> had ever heard of such a thing.
>
> Thanks!
>
> Neil

Never heard of it. Revoke delete permissions from all your users. Add
a trigger prohibiting any deletes.

[Back to original message]