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 |
|
mvpng
Starting Member
2 Posts |
 Posted - 2009-01-07 : 20:12:06
|
| My MSDE 2000 Database have the data missing problem recently. One or more rows of records will disappear suddently.Sometimes, the records value will automatically changed to other value. For example, ACNO will changed from 9021 to 9241. I have checked and confirmed that nobody have deleted/updated the records.I also have perform DBCC CHECKDB to check for database corruption.However it show the database is free from error.So could any body help/suggest me to solve this problem?Thank you. |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2009-01-07 : 21:19:56
|
| Why Can't you run SQL Profiler to track only changes?hey |
 |
|
|
mvpng
Starting Member
2 Posts |
Posted - 2009-01-08 : 03:15:07
|
| Eh...How to run SQL Profiler from MSDE 2000?SQL Profiler only available in SQL SERVER but not MSDE right? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-11 : 13:47:42
|
quote:
Originally posted by mvpng
Eh...How to run SQL Profiler from MSDE 2000?SQL Profiler only available in SQL SERVER but not MSDE right?
What does PROFILER80.EXE say in run? |
|
|
|
|
|
|
Data Missing Problem