How to find the database version

I detached a database from an SQL server V7 ,
then attached it to an sql server V8 (no migretion)
Runing sp_helpdb shows Version=539 and compatibility_level 80 for all
databases.How can I see tha my databse is actually a V7 version ?
Thanks
When you attach an SQL Server 7.0 database to SQL Server 2000, that database
automatically gets upgraded to SQL Server 2000.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"and" <and@.discussions.microsoft.com> wrote in message
news:40EA21A1-45E9-4282-9037-FEEC90B53F7E@.microsoft.com...
I detached a database from an SQL server V7 ,
then attached it to an sql server V8 (no migretion)
Runing sp_helpdb shows Version=539 and compatibility_level 80 for all
databases.How can I see tha my databse is actually a V7 version ?
Thanks
|||When you attached it, you should have seen messages noting it was upgraded.
It is now a SQL 2000 database.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"and" <and@.discussions.microsoft.com> wrote in message
news:40EA21A1-45E9-4282-9037-FEEC90B53F7E@.microsoft.com...
> I detached a database from an SQL server V7 ,
> then attached it to an sql server V8 (no migretion)
> Runing sp_helpdb shows Version=539 and compatibility_level 80 for all
> databases.How can I see tha my databse is actually a V7 version ?
> Thanks
|||Hi,
You can get the database version by running the below command from Query
Analyzer:-
sp_helpdb <dbname>
See the "compatibility_level " in the result.
FYI, While you attach the database in Query analyzer you can see messages
stating that datbase is getting upgraded.
Thanks
Hari
MCDBA
"and" <and@.discussions.microsoft.com> wrote in message
news:40EA21A1-45E9-4282-9037-FEEC90B53F7E@.microsoft.com...
> I detached a database from an SQL server V7 ,
> then attached it to an sql server V8 (no migretion)
> Runing sp_helpdb shows Version=539 and compatibility_level 80 for all
> databases.How can I see tha my databse is actually a V7 version ?
> Thanks