You want to be careful using a fixed % since as you file gets bigger soon 10% is a huge chunk to get allocated at one time.

We use RedGate, all in all a decent product that gets the job done, also their support is very good.

Ok, it been a while...

I don't think 2000 has a 6.5 compatibility mode. Also I think they added some keywords between 6.5 and 2000 so that may be...

You could do it with a trigger and a trigger and a xp_sendmail call.

Not to join in the flogging of the 'don't shrink' idea but in general it is a bad idea to shrink the log file.

You may want to look at...

There is a chance there could have been a hung connection. Also depending on what you were doing to find out that there was no-one in the DB (sp_who2)...

Then the union mentioned above is the way to go

So you want two rows to be returned and have them as the first two rows in the result set regardless of if they match your search criteria.

or

do you...

Do you have some sort of job or large query that runs at a regular interval that might be causing a table lock?

Another option when you get a index error message is to just drop and re-create the index. If it is a clustered index then you may have more of an...

Not sure if you can commit someone else's transaction, as for a rollback you can kill it, that will force a rollback.

As for the last statement try dbcc inputbuffer(spid)

Yeah I saw that, good to know I am not the only one seeing this.

I set it up replication monitor.

Toss an id on it or use the date and delete in 1 mm record chunks and loop and go into simple recovery mode if you can. I have...

So are you sure that it was the backup set of the job that failed? Have you checked the SQL Server Error log to see if there were any...