Yes I realise that the way the backup is setup removes the log file and it has been ok up to this issue, so was more looking for a best...

Thanks for your reply however I want to see how much physical space in KB each index takes up.

Ashish, thanks for your help but it misses what I want to do.

I want to find and document the poorly written views and then tell the developers to fix them

I have alreasy done that but it doesn't really lend itself tom easily identifying the ones with most nests. There is hundreds of views.

Sorry for the delay. I should have said that file - print of course would print it out but the complexity of the execution plan means it prints on...

Fantastic, thank you

Experienced the same when deploying a 75 user application. We bit the bullet and bought a new server for running reporting services although that did cost us a another...