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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Tracking changes made to a database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-08 : 11:33:42
Chris writes "I'd like to be able to log the changes made to a database with ASP/ADO. More specifically - I'd like to know what was changed, who changed it, and when it was changed. My site already uses an SQL driven login system and the username is stored in a session variable. The log could be kept in another data table or a text or html file, whatever is easiest. I'm using Windows 2000 Server SP1, IIS 5, ASP, ADO 2.5, and Access 2000.

thanks,

Chris"
   

- Advertisement -