If the trigger fires before the event then you can do an sp_rename on the original sproc.

Just an idea, might not work.

What are the size of the indexes that you are using?

Also do the errors tell you which T-log is running out of space?

I think the TempDB one gets used as...

I have already purchased a 'Learning Bundle' which has not arrived yet and cannot remember which books are in it.

How many, and which, books are in both bundles?

Thanks

I am not sure that is all that manually hitting start/stop does.

Run a profiler with SP:Starting and RPC:Starting and you should be able to capture the chain of procedures called.

You...

Thanks for this.

I think the lack of the following would make most really useful CLR sprocs unsupported.

using System.Data.SqlTypes; -> Not supported

using Microsoft.SqlServer.Server; -> Not supported

using System.Diagnostics; -> Not supported

This will...

I would question the practice of giving all the memory to SQL server. In my experience limiting SQL Server so that it does not take all the memory...

That would imply a server setting or session setting was changed.

This was then reset to default on reboot.

Not sure what it might be though.

You can also reserve a large amount of disk space for the T-Log. Therefore it won't need to autogrow as often.

Maybe an alert when it gets close to...

Check for differences between the server settings inc. @@MAX_PRECISION and service pack level.

Also any patches which may have been applied to SQL Server.

Swithcing between tabs in firefox seems a real killer with these ads. The switch takes several seconds. With normal pages it is instant.

Prefer the old banners...

What happens when you try to connect using Management Studio and run queries after failover?

Do you get any errors?

Also try a creating a UDL from a client machine.

Also check the...

Are you using syncronous transactions?

Have you considered using the bulk-logged recovery model during the re-index operation.

If certain criteria are met then Reindex statements can be minimally logged which would reduce network load.

Check the following...

Have you run a DBBCC CHECKDB?

If so what information does it return regarding this table?

Richard

I have never taken 70-299 but the ones I have taken had 40 questions. I have never found the time limit to be factor in the exam but...