yes you will need to stop and restart the sql server.

The failed login information is stored in the sql log files

The failed attempt has the time and a line like "Login failed for user 'tmprm'"

If you are deleting all the rows from a table try using 'truncate table' it is a lot faster than deleting than all

There are two server roles which allow people to drop databases

ie 'System Administrator' and 'Database Creator'

I'll try Technet, and I looked in BOL prior to the orgional posting.

Brian,

Its both really, since the two do marry up. (the exception.log error file SQL puts into the logs...

Thanks Brian, makes sence.

Just looked at MSDN. Q256650 also has a script for creating dummy transactions

Its was discussed on a previous thread (less than a couple of months ago if I remember correctly).

I had the same problem a while back, with a 30gb logfile. Hence...

You only need to detach the database if the log file is over 1GB in size (sql doesn't shrink logs over this size)

If the audit was changed to 'audit failures only', but not stopped and restarted I think it would carry on logging the lot.

You can sort of restrict 'domain admins' by removing the builtin/admin for the admin group (not exactly advisable) as this can cause problems with full text indexing etc.

The advanced server box is set to default, whereas the NT box has been modified eg Fibers, min memory query, max worker threads etc.

I will look at the SP to...

I didn't write it myself, but basically the data are logs and it is tidying up the data and inserting the required clean data into a more useable table.

Accounts with SA rights have access to the lot. I don't know of a way to restrict sa access

Found the solution just after posting the

question

If I execute the sp_executesql command from the destinaction database it works eg.

EXECUTE northwind..sp_executesql @SQLString

I currently use Veritas for the overnight backup only (and only for my sql 6.5 & 7 db's, the version we have doesn't support 2000).

Again the server support team...