Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog.
Monthly Archives: October 2005
The installation path for SQL Server 2000 can be determined using the undocumented sp_msget_setup_paths Stored Procedure.
Below is an example of how to use a Trigger to audit who updated, deleted or inserted data. The trigger also captures the old and new values when an update is performed:
The September edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.