sp_help 'tablename' will display all of the information you need and some extra stuff too.

Chris

Excellent thanks a lot.

Thanks again much appreciated, I don't know which SAN vendors have been aproached that is being looked into by our infrastructure team. They have been asked to shortlist 3...

Thanks guys we have a very high I/O throughput but the transactions are relatively small. The schema isn't the best but the current business demand means we are unable...

There are arguments for and against removing the Builtin\administrators group. The below linked article should help.

http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/

use the cluster resource utitlity to backup the cluster resource checkpoints prior to moving to the new hardware. That way if you have a problem with the quorum disk...

Why are you moving the Cluster? how did this idea come about?