Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mehdi.romi
Starting Member
1 Post |
 Posted - 2007-08-21 : 02:09:22
|
| Hi,I have a massive sql 2000 database that an asp web application uses it. the problem is that one of tables is losing its records automatically without any logical reason. I have also say that there is no DELETE sql command in any applications, store procedures & sql jobs. ( I flag records as Deleted rather than actually deleting. in addition, there is a triger on my victim table that says in case of delete command, delete a record from another table that guaranties no delete command should be executed on this table alone without expecting another delete in the second table.I have also disabled all ms sql jobs, sprocs. and there is no database user with DELETE permission ( even sa )I tried to monitor everything with Profiler but shows nothing unnormal and that why I am absolutely shook now !!!Could anyone help me with this prob please?Thank you Regarads,Medi |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-21 : 02:52:59
|
How about transactions?How about TRUNCATE?Post the code for the TRIGGER, please...
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 23:01:02
|
| Or use third party tool to read transaction log. |
|
|
|
|
|
|
Losing MS SQL Server 2000 data