Do you have a keyboard with an "F-Lock" key? If F-Lock is off, the default for F5 is the open file dialog.

Using Enterprise Manager, right click on the server, select properties, then select Security Tab.

Hal

Actually simple. I just union the current log table and the history log table in any select that needs information from the complete history. BOL has good examples of Union.

Hal

Actually, yes this log can grow quite large depending on the volume. We archived the log file monthly by appending it to a table on our data warehouse (it generaed about 50k records...

I didn't include any foreign keys to this table. I of course used foreign keys in the user tables but for this log table I wanted exactly what was changed...

I worked in a situation where knowing in detail what was changed in a database was critical. I used a single log table to capture all inserts and updates to...

Look up -

system tables, direct updates

in BOL. This will show you how to alter system tables

If you change the set statement from:

  SET @sql=N'SELECT name FROM '

to:

  SET @sql=N'SELECT name as ' + @db + ' FROM '

it makes it easier to distingush the...