Good point about tempdb.

The initial recommendation was to install a second instance with binary collation, but we pushed back on the vendor asking why a dedicated instance is needed to...

Having the vendor agree to the change, while continuing support of their application isn't the issue. They agreed to the change during the planning stages of the project and...

We asked the vendor at the beginning of the project why binary was necessary and they initially said it would yield a 30% performance gain, but they could not explain...

Thanks everyone. Here's the tricky part. This is a vendor's database. We have there application's DBs stored on a shared development server. We have yet to...

That makes sense if I were comparing the two collations, but after running the ALTER TABLE...ALTER COLUMN all tables will be the default sort order/collation. Wouldn't comparisons at that...

Red Gate will work when we want to script an entire database, but if we want to script specific items such as indexes and constraints only, then Red Gate won't...

We have Red Gate, but have never used it to script databases, only compare. I'll give that a try.

In regards to the question about performance it's just not acceptable...

I agree completely. Supposedly MS decided to require sysadmin permission because in 2000 it was possible for someone to manipulate debugger to elevate their permissions.

Well that stinks. Not sure why MS didn't follow the security model they use with Active Directory.

I still owe Microsoft a call on this one, but I don't expect any real help. I'm hoping 2008 will have addressed this issue, however that won't help our...

We did follow the first approach (IP Address, Network Name and Physical Disk), but we forgot to enable it in Windows Server 2003. The strange thing is that particular...

Thanks Jeff.

We only have three clusters and on the first one we configured we did not enable MS DTC. If we go back and enable it will...

Do you know what causes the DTC service to start on the passive node?

I assume from your answer the DTC service should be left in MANUAL mode.

Thanks, ...

There are no Denies.

I'll give it a try.

Thanks