Francisco Tapia
fhtapia at gmail.com
Fri Sep 12 09:44:36 CDT 2008
One method to ensure you block what is happening.... you can run profiler and monitor for just the tblPersonnel, there are also products out there I think there is one by quest software that will allow you to view the transaction long (you can download the demo and review). Along with profiler you can also add some security simply lock down the security to prevent deletes in this table. hopefully your app uses a uid that is not the sa or administrative account. once that occurs you can deterime once and for all if it is your app (or if it's someone else) hth -Francisco http://sqlthis.blogspot.com | Tsql and More... On Fri, Sep 12, 2008 at 12:25 AM, Paul Hartland < paul.hartland at googlemail.com> wrote: > To all, > > Over the last two days we have been losing personnel off our main database, > and have had to retrieve them from one of my many backups. However I can't > seem to see why or where this is happening in my application (VB6)...Does > anybody know how to view the LDF files, so that I can see each transaction > as it takes place, or if there is something I can do when a record is > deleted from tblPersonnel, or if I can turn on some sort of monitoring > system ? > > Thanks in advance for any help on this. > > -- > Paul Hartland > paul.hartland at googlemail.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >