Re: SQL Server 20005 Licensing

try this...

SELECT
CAST( SERVERPROPERTY('productversion') AS varchar(15)) AS productversion,
CAST( SERVERPROPERTY ('productlevel') AS varchar(15)) AS productlevel,
CAST( SERVERPROPERTY ('edition') AS varchar(20)) AS edition,
CAST( SERVERPROPERTY ('licensetype') AS varchar(15)) AS licensetype,
CAST( SERVERPROPERTY ('numlicenses') AS varchar(15)) AS Numlicenses


--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"twilliams" <twilliams@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DABAA9E-DEC3-41D3-BE9B-D1249E326FEC@xxxxxxxxxxxxxxxx
Thanks Warren. The eval has not expired yet however, we purchased an SQL
2005 standard edition. When I downloaded the trial version originally, I
can
not recall it giving me a choice of which trial version to download
(Standard
or Enterprise). How can one confirm which trial version they are are
running.

Thanks
TomW

"Warren Brunk" wrote:

Short Answer: If it isnt expired then you can just run an update. If it
has
expired you will have to uninstall then reinstall.
http://support.microsoft.com/kb/914158

http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx

Upgrading and Uninstalling the Trial Software
The 180-day trial version of SQL Server 2005 Enterprise Edition can be
upgraded to the fully licensed version of SQL Server 2005 Enterprise
Edition
without uninstalling the trial software prior to the end of the 180-day
period. If upgrading to the fully licensed version of SQL Server 2005
Standard Edition, Workgroup Edition, or Developer Edition, it is
recommended
that you uninstall the 180-day trial version of SQL Server 2005
Enterprise
Edition before installing the fully licensed version of the other
editions.
Please refer to the product documentation for information about upgrading
to
the fully licensed software.

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"twilliams" <twilliams@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:09BDBD49-7C4F-46AD-851E-7085F36A6450@xxxxxxxxxxxxxxxx
I downloaded an 180 day eval copy of SQL server 2005 and we wish to
utilize
it. However, we purchase an Open License. Is there a wey we can
upgrade
the
Eval SQL 2005 using the open license we purchase.

thanks
TomW





.

Relevant Pages

  • Re: SQL 2005 SP
    ... I don't have a case-sensitive server handy to test this on, but perhaps the property names are case-sensitive in a case-sensitive instance. ... You might try specifying the proper case names documented in the Books Online: ... SERVERPROPERTY, ... How to chekc which SP I've installed on my SQL Server 2005..? ...
    (microsoft.public.sqlserver.security)
  • Re: Licensing
    ... Then the licence type shuld be disabled. ... Run the below command and see:- ... SELECT SERVERPROPERTY, SERVERPROPERTY, ... SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 SP
    ... Are you getting NULLs? ... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY as ... How to chekc which SP I've installed on my SQL Server 2005..? ... Tried the following query: ...
    (microsoft.public.sqlserver.security)