Determine who entered data?
This is a discussion on Determine who entered data? within the SQL Server forums, part of the Microsoft SQL Server category; --> Someone entered a lot of incorrect data into our SQL 2000 database. Is there any way to determine who ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:51 PM
| ||||
| ||||
 Re: Determine who entered data? rotk fan (rotk_no_spam_1972@yahoo.com) writes: > Someone entered a lot of incorrect data into our SQL 2000 database. Is > there any way to determine who made the changes? Maybe. If you are running in full recovery mode, and have the money to cough up for a license of Lumigent Log Explorer, see www.lumigent.com. If you are really lucky, the application may have some auditing on its own. In any case, there is nothing built into SQL Server for this. -- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp      |
Linear Mode
