Thanks Grant, that's an interesting idea.

Did you store absolute versions of the records each time? We have a couple of TEXT fields so I think that space may become...

I guess it depends on how much you know already and what you want to design a database to acheive (i.e. OLTP or OLAP), and so on.

I've never actually read...

I agree with the other replies.

Just for info, when a row is physically stored (in 2005) in the page the following sequence is used:-

* First, the Header,

* Followed by Fixed...