Re: SQL 2005 SP

From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 27 Apr 2007 08:04:50 -0500

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:

SELECT
SERVERPROPERTY('ProductVersion'),
SERVERPROPERTY ('ProductLevel'),
SERVERPROPERTY (Edition')

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R" <R@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AA4163D5-567A-49DF-88A5-EEFC68E3BEAC@xxxxxxxxxxxxxxxx

Hi,

How to chekc which SP I've installed on my SQL Server 2005..?
Tried the following query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

Doesn't give any info.

Thanks

R

Follow-Ups:
- Re: SQL 2005 SP
  - From: Erland Sommarskog

Prev by Date: Re: Granting consultant access to database
Next by Date: Re: Login succeeded followed by Logon Failed
Previous by thread: Re: SQL 2005 SP
Next by thread: Re: SQL 2005 SP
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Server 20005 Licensing
... CAST(SERVERPROPERTY('productversion') AS varchar) AS productversion, ... CAST(SERVERPROPERTY ('productlevel') AS varchar) AS productlevel, ... Upgrading and Uninstalling the Trial Software ... The 180-day trial version of SQL Server 2005 Enterprise Edition can be ...
(microsoft.public.sqlserver.setup)
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)