K Allen Scott from OdeToCode has a great series on versioning databases. Definite must read stuff for SQL development.
http://odetocode.com/Blogs/scott/archive/2008/01/30/11702.aspx
http://odetocode.com/Blogs/scott/archive/2008/01/31/11710.aspx
http://odetocode.com/Blogs/scott/archive/2008/02/02/11721.aspx
http://odetocode.com/Blogs/scott/archive/2008/02/02/11737.aspx
http://odetocode.com/Blogs/scott/archive/2008/02/03/11746.aspx