For the future, you can use CDC (Change Data Capture) to get that kind of thing.
In order to track down past changes, you'll need to check the transaction log. Is the database in Full, Bulk Recovery, or Simple, recovery model? If Simple, then the data is gone and you can't track it down. If Full or Bulk, you should be able to get a log parser application to find the data changes in there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon