I would change the ASP to connect using the IP address rather than using the DNS name (presuming that's how it's set up) and use SQL Auth if you are...

In real world scenarios with clusters pretty much the only occassion I've seen a cluster failover automatically was when one of the nodes crashed due to a hardware fault.

Other than...

A better course of action would probably be to change the DSN.

Basically, as the SQL service account that you are using is not a domain admin and does not have sufficient priveledge to register itself correctly in active directory. Using the...

Or you could DTS the data in at intervals.

I would use setspn to resolve the problem, it's one less thing that you have to concern yourself with from that point on (and the fix only takes a matter...

You would need to make sure that the login you are using has access to the database and table that you would be updating when the trigger fires.

Do you need to change the signatures?

If you have basic disks I am not sure that there is a guid type disk signature written that windows needs to understand.

Just a quick note, this will give you all the commands that you need to run, you can then remove any databases that you don't want to change the recovery...

Was the target server shut down also?

Did you shut down the servers involved prior to making the disk changes?

Given that the cluster service keeps a track of whats going on, I wonder if having the servers...

What about create a new table, insert the relevant records into the new table, stopping at (for arguments sake) 8am today.

Rename the current table to old and the new table...

Does that user have permissions to create a view in the database?

You have to bear in mind that an outer join will return every record from the left table, whether there is a matching record in the right table or not....

Have you run execution plans for the procs that are causing the problems to see if there are any glaring problems like table scans etc?