This is generally caused by having a lower version of the client tools accessing a higher version of the database. For example, your client tools are probably at RTM...

I find this section the most interesting:

06/09/2009 10:18:50,spid94,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0376.txt

06/09/2009 10:18:50,spid94,Unknown,**Dump thread - spid = 94 PSS = 0x51F2B5E0 EC = 0x51F2B5E8

06/09/2009 10:18:50,spid94,Unknown,Using...

There is a very good article on this site about setting up Kerberos. Here are a few of my thoughts on your issue:

1) Running as sysadmin does not guarantee...

Robb (6/22/2009)

---

True, there is a window of time between the first full backup @ 4a and the first trans log backup @ 7:15a but there are not many users (if...

Glad I could help - I am happy to hear that you already have the tools, now it's just a matter of setting it up.

And there is your problem. Find out what time that file is getting backed up...

Are you backing up to a differently named file each time? Or, are you backing up to the same file all the time?

If the same file, then you are...

I would spend the money on Redgates SQL Compare tools. You would need the professional version to be able to automate the process daily.

What you would schedule would be...

In a cluster, the SQL Server service is not running on the non-active node. When the failover occurs, Cluster Administrator starts SQL Server on the non-active node making it...

Using Powershell, the first step is to load the SMO libraries:

PS> [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO") | Out-Null

The next step is to setup the list of the SQL Server instances we want to access,...

Jeff Moden (6/21/2009)

---

One other thing... I don't use the maintenance plan to rebuild indexes on very large databases that also have a lot of static lookup tables. I'll use...

GilaMonster (6/20/2009)

---

So if you're using the default maint plans, updating stats after rebuilding indexes will (I think) lead to a...

The automated way of handling this is to perform regular transaction log backups. Every hour would be a good start, but you then need to follow up with the...

The maintenance plan plug-in uses UPDATE STATISTICS. I get around this by using an Execute SQL Task and executing:

Use db1; Execute sp_updatestats @resample = 'RESAMPLE';

Use db2; Execute sp_updatestats @resample...

GilaMonster (6/20/2009)

---

Updating stats after an index rebuild is a poor idea. A rebuild of an index automatically updates stats on that index with full scan. If you then do a...