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 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 us get an understanding of where
things go and what is happening... any would be greatly appreciated..


--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008

You can run SQL Server Profiler (7.0) / SQL Profiler (2000), and simply
capture all submitted statements. it might be a bit overkill, but it
will work.

--
Gert-Jan
SQL Server MVP


Daniel wrote:
>
> 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 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 us get an understanding of where
> things go and what is happening... any would be greatly appreciated..
>
> --
> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008