we have a few servers that are running SQL7 and SQL2000

we are looking to move them and upgrade them to SQL2005, but some of the
DB's within these are still being used daily, but most of the programmers
that created these DB are no longer with us so we are trying to find out
what uses them and so on..

As with SQL2005 you have the audit logs that you can review when a procedure
is executed, what data was passed to the procedure and so on.. is there
something we can turn on within SQL7 and SQL2K to help us determine when
data is being put into the tables? and so on..

We have found a few windows scheduled tasks that call VB scripts that have
SQL connection strings to these databases..

So is there maybe some triggers we can write to see what tables are being
updated an at what time the update occurred?

This is only a temporary thing to help us get an understanding of where
things go and what is happening... any help would be greatly appreciated..