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
JerryNew Table. :-)
HTH, Jens Suessmeyer.|||You have to customize this using a table but there is no built in informatio
n.
"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.googlegroups.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
>