Get Version of Database

Hi,
Does a SQL Server database have a version number assoicated with it.
We are going to be continually updating a database and would like to
associate a database version with each update e.g (1, 1.1, 1.2...etc)
Is there a version property of the database I can use or will I have to
do it with a new table
Thanks
Jerry
New Table. :-)
HTH, Jens Suessmeyer.
|||You have to customize this using a table but there is no built in information.
"JeremiahOSullivan@.gmail.com" wrote:

> Hi,
> Does a SQL Server database have a version number assoicated with it.
> We are going to be continually updating a database and would like to
> associate a database version with each update e.g (1, 1.1, 1.2...etc)
> Is there a version property of the database I can use or will I have to
> do it with a new table
> Thanks
> Jerry
>
|||Hi,
You have to create a new table and need to write a new stored procedure to
store the versions. ALl manual.
Thanks
Hari
SQL Server MVP
<JeremiahOSullivan@.gmail.com> wrote in message
news:1128502216.266668.98490@.g43g2000cwa.googlegro ups.com...
> Hi,
> Does a SQL Server database have a version number assoicated with it.
> We are going to be continually updating a database and would like to
> associate a database version with each update e.g (1, 1.1, 1.2...etc)
> Is there a version property of the database I can use or will I have to
> do it with a new table
> Thanks
> Jerry
>