Determine who entered data?

#1

Someone entered a lot of incorrect data into our SQL 2000 database. Is
there any way to determine who made the changes?

Thanks in advance.

#2

rotk fan (rotk_no_spam_1972 (AT) yahoo (DOT) com) writes:

Quote:

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 (AT) algonet (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Determine who entered data?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Determine who entered data? - 09-10-2003 , 03:42 PM

Re: Determine who entered data? - 09-10-2003 , 05:13 PM