> what is the best approach to assign a version to the database.
> Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,, I'm looking at storing it with
> the DB itself. Is there a way to store it and read it from system variables?..
> I wanted to use a DB field but it sounds too much for what I want to
> accomplish.

We created an SP (Get_Schema_Version) which we update when we deploy new schema.


Sean