Cheers for the reply Mel. I was wondering what the benefits are specifically in relation to Change Tracking. As far as I can work out, it could be something to do with the reads not acquiring locks and therefore not blocking modifications, and consistency between multiple select statements but I was hoping that somebody clever than me could confirm this and maybe add to it too. Or more likely, give me the real reasons! 🙂

Cheers,

Tim