Oops! Ditto what Brandie wrote...

I think that best practice is to create indexes after the load.

Otherwise you are doing index maintenance for each insert operation which I would think would be substantially...

Oh yeah, have to add... "Please be careful modifying permissions in the registry." etc., etc... 🙂

All the same it is a good idea to verify that the account has rights.

Look at the permissions set for the AuditLevel value in the registry and verify that there...

...and, I have the results of the two DBCC LOGINFO executions if that is of use to anyone.

Now you are just stirring up trouble... 😀

RBarryYoung,

Thanks for the reply. I figured as much, but am ever hopeful for the hack/cheat.

I am lucky that SP3 will resolve my need in this case, however I still...

It is a service, but it needs a shared disk resource when installed in a cluster.

-Dan B

I've certainly been wrong before, but it is my understanding that you will need to set up the OS Cluster first and then install the SQL Server instance. I...

That is good news, but I would be very surprised to see SP3 released before Spring 09.

"...I’m happy to inform you that we will in fact deliver an SP3 following...

How soon is pretty soon?

Got this from our Rep yesterday in response to a question on SP3:

"I’m told that there is not a plan for SP3 at this time. From our perspective, there...

There is still no formal statement from Microsoft.

A quick version history:

RTM – Nov 7, 2005

SP1 – April 19, 2006 ( 5 months )

SP2 – Feb 20, 2007 (...

Somehow I knew this wouldn't be a hot topic... 😀

A fair point, but in this case, the agency wants a hole outbound, not inbound. Their risk is limited to loss or exposure of whatever data is stored in...