How to tell if I have the Personal or Enterprise Edition of SQL 7.0

I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
how to I know which edition I have?
Thanks,
DanSolex,
From KB321185 :
How to Determine Which Edition of SQL Server is Running
If you are not sure about what edition of SQL Server you are running, the
last line of output that is returned by @.@.VERSION reports the edition to
which you have connected. The example that is used in this article is the
Standard Edition of SQL Server 2000 on Windows NT 5.0 (Build 2195: Service
Pack 2) Note The build and service pack information provided earlier is for
the operating system, not for SQL Server.
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||So the desktop edition is the same as the personal edition?
Thanks,
Dan
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OITp%23$LaDHA.2580@.TK2MSFTNGP09.phx.gbl...
> In Query Analyser do this
> SELECT @.@.version
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org|||Try:
SELECT @.@.VERSION
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to
upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||Is there any thing I should look out for when upgrading from the Desktop
Edtion 7.0 to the Personal Edition 2k?
Thanks,
Dan
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>|||Dan,
In SQL2000, "desktop" edition(DE) was renamed to "personal" edition(PE).You
can upgrade SQL Server 7.0 DE to SQL2000 PE.Just pop in the setup CD and
select 'upgrade existing installation...' and it should go fine.On a
successful upgrade, all your SQL7 databases would be upgraded to SQL2000
ones.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"solex" <solex@.nowhere.com> wrote in message
news:%23d%23Z3DMaDHA.2284@.TK2MSFTNGP12.phx.gbl...
> Is there any thing I should look out for when upgrading from the Desktop
> Edtion 7.0 to the Personal Edition 2k?
> Thanks,
> Dan
> "solex" <solex@.nowhere.com> wrote in message
> news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> > I am currently running SQL 7.0 on a Win2k workstation but wish to
upgrade
> > how to I know which edition I have?
> >
> > Thanks,
> > Dan
> >
> >
>|||Thank You All!
"solex" <solex@.nowhere.com> wrote in message
news:urKWw9LaDHA.736@.TK2MSFTNGP09.phx.gbl...
> I am currently running SQL 7.0 on a Win2k workstation but wish to upgrade
> how to I know which edition I have?
> Thanks,
> Dan
>