Glad you like the comics. I'll pass the word.

The water is like 8 or 9 blocks, and while it's a bit of a hike coming back, it's walking distance. Lots of hotels around, and I'm sure Gail can...

I think it speaks more to someone's inability to deal with frustration, improper presentation of their opinion, and the likelihood that he/she will inappropriately use sarcasm.

Definitely not a team player,...

Do you have a question?

The size calculation for all the indexes is the same. A little over 2x the index size since it is a transactional process.

Not sure I'm correct. Kind of throwing things out in the dark. You covered a lot of things, that was my small guess as to the issue.

That's not available in 2000. You posted in a 2005 forum, so you got answers for that.

I'll move this to 2000.

You likely need to use Profiler to find queries. Not...

No worries. I understand, and it made me rethink it a bit. It's debatable if this is worth two points, and I'm happy to have the opinions. I just eyeball...

Sorry, my bad verbiage. I meant node.

The endpoint is a server setting, and depending on how the cluster was set up, I was thinking that perhaps the endpoint didn't get...

I like Jack's solution, though I might update, delete the matches, insert the rest. Not sure which is better.

I don't think you can get a count of the failed logins per user. They're logged, but you'd need to load that into a table and query it. There might...

Strange, same code? Same server?

Wow, please learn to separate your post out into paragraphs. It's hard to read what's going on with the formatting.

There are a few causes of SSPI errors. Try these resources:

http://www.sqlservercentral.com/Forums/Topic694576-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic658203-146-1.aspx

http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/

A trace is probably your best bet here. If you know the time, FileWatcher, from Sysinternals, can also help you trace down the accounts trying to do the access. That...

Is the endpoint set up on both clustered instances? I could see that as an issue.