Re: SQL 2005 SP

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Thu, 26 Apr 2007 09:39:13 +0300

R
What does it mean '> Doesn't give any info'? Are you getting NULLs?
Make sure that you are on the 'right' server

SELECT SERVERPROPERTY('productversion') , SERVERPROPERTY ('productlevel')as
Service Pack,

"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

Prev by Date: Re: GRANT ALTER TRACE in MSSQL 2000
Next by Date: Re: Creating specific users
Previous by thread: Re: GRANT ALTER TRACE in MSSQL 2000
Next by thread: Re: SQL 2005 SP
Index(es):
- Date
- Thread

Relevant Pages

Re: DTS Problem
... You will have to ignore those columns, by selecting ignore from the combo ... NULLs, then you could use a COALESCE or ISNULL function in your source query ... Vyas, MVP (SQL Server) ...
(microsoft.public.sqlserver.server)
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: 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)