Further information, the calls to sp_MSunmarkschemaobject, although excessive, take very little time. It calls this SP for each and every object in the database once per change. So if you...

Had a chance to look at this today. It runs the sp_MSunmarkschemaobject on every object (I think), irrespective of whether it has been touched by the trigger/sp changes. This...

No it's definitely a transactional replication publication.

I will turn off the auto create stats - still a little confused though. The statistic was a weird name (hind_133213 or something) which...

Ah OK. I thought that Node B was always passive, if you wanted to run another instance on another server you had to have another node (to achieve some sort...

 I wasn't thinking of putting IIS/SSRS with SQL-Server - they will be on their own clusters.

I was more interested in what to do with SQL-Server. My understanding is that for...

Thanks Ron, the Kerberos information is great.

I already have planned to replicate (it's not snapshot unfortunately has to be transaction as the data must be available immediately) from the data...

It's so you can write CLR functions - which are considerably faster, more powerful than UDF's. BOL has a load of info on it - search for CLR.