Jeff,

This is the proper clustered index and it makes up the primary key on the table. This is a wealth management database, so the data that will be inserted again...

Jeff,

Thanks for the hint on the clustered index. I was checking out the table and the execution plan and was scrolling through everything that would be affected and found that...

One other thing that I wanted to see if anyone has some knowledge on is doing these updates as part of a bulk update instead of having each update logged...

At this point, if you are not going to install the SQL 2008 Client tools, then I would either open an incident with Microsoft or see if you can find...

Great news and thanks for posting!

What I found is that the SQL 2008 Components just install some updated DLL's. When SQL 2008 is pulled off the boxes, the updated dll's...

If you are getting those errors now after uninstalling SQL Server 2008 and doing just fresh installs of SQL Server 2005, I would try installing the SQL Server 2008 Client...

We have resolved this issue after reviewing the Cluster log.

We found that when we had installed and then uninstalled SQL 2008 from the second node, it corrupted the ODBC drivers...

Just in case someone happens to stumble across this issue, here is some clarification on this issue after working with Microsoft support.

1. SQL 2008 has been changed in the way...

Thanks for the post. We have completely removed SQL from this cluster and are rebuilding from scratch again (good for documentation purposes).

I will try and download that update and give...

Just to make matters worse. After uninstalling SQL Server 2008 all together from our cluster, now the SQL Server 2005 install is experiencing the same behavior. Prior to the SQL...

I have actually found that the SQL 2008 installs vary tremendously from the clustered installs of SQL Server 2005.

In 2005, it would determine what nodes were part of the cluster...

That is about where I am at right now. Luckily this is the Dev Cluster, so I'm going to just clean up both boxes, get a clean SQL Server 2008...

Thanks for the help! I'm stumped at this point especially since it's happening on all 4 of our SQL Servers.

Also, I did check to make sure that the db compatability...

I already queried the sysdatabases table and found that this database is in there and it is listed with the full name; that was actually the first thing I checked.

The...

In addition to setting up Database Mail, there is one other thing I would check if you are going to be sending notifications based on SQL jobs. Once you can...