I'm not at all sure what the license model is, but I'll inquire with the MS rep. We do need the additional nodes, because of incoming systems, the current database...

I don't think I can do the backup/truncate part. this is part of the production database and for reasons I can't detail here, I can't use our normal backup solution...

Normally this would be ok but these are for some vendor products which require conflicting character sets on the tempdb and other db's , and don't seem to play well...

Does each instance need a quorum drive? Or is there only one per clustered environment?

Thanks. I probably need to be clearer. The part that's most throwing me, is the concept of the cluster groups. This is my first time with this.

I have a 2...

Thanks!

Relatively new here...what is BOL?

Hmmm, that's what I thought. The query, although running, shows up incomplete in that as well. It's like there's as special character or something that's causing it to display funny....

Doh! My mistake. I didn't notice the forum header had changed when I was looking originally. I posted this in the 2000 forum. I didn't see how to delete this...

When I run that, in the Master DB, it has an issue with the cross apply as well as the sys.view or table. Is that a SQL Server 2000 or...

Thanks Toby!

The part I don't fully understand is what will be placed in rollback. This system will have maybe one connection, from a default connection pool via an app server....

Thanks Jeff! Do I have to...

I didn't specify; it's sql server 2005.

Can I kill by user name? I won't be able to get the PID as it's different each time.

Explain the "splitbrain" thing a bit if you can.

The goal is to run a 4 way that can fail over to another 4 way. That's the extent of the high...

No, I was under the assumption that the witness server monitored the clusters and provided the heartbeat. I knew it was for mirroring, but I thought it also was for...

Thank you very much! Clear, and it did the trick.