title: How do I version a SQL Server Database?
body: <p>I need to put versions onto a SQL Server 2005 database and have these accessible from a .NET Application.  What I was thinking is using an Extended Properties on the Database with a name of 'version' and of course the value would be the version of the database.  I can then use SQL to get at this.  My question is does this sound like a good plan or is there a better way for adding versions to a SQL Server database?</p>
  
  <p>Lets assume I am unable to use a table for holding the Metadata.</p>