October 31, 2007 at 10:05 am
I am executing 2 different queries as follows:
select @@version
SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY ('productlevel') as ProductLevel, SERVERPROPERTY ('edition') as Edition
For the first (suggested by Microsoft)I get:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
For the second I get:
ProductVersion ProductLevel Edition
9.00.3054.00 SP2 Enterprise Edition
Why do I get Service pack 1 for one and service pack 2 for the other?
October 31, 2007 at 10:17 am
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Its the service pack of the OS and not of SQL Server.
--Ramesh
October 31, 2007 at 10:26 am
That makes sense but at the site http://support.microsoft.com/kb/321185 it says:
How to determine which version of SQL Server 2005 is running
To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The results are:
•The product version (for example, "9.00.1399.06").
•The product level (for example, "RTM").
•The edition (for example, "Enterprise Edition").
That doesn't sound like the OS!!? Are you sure? Is it poor wording by Microsoft?
October 31, 2007 at 10:40 am
What Microsoft said is absolutely correct...
I just clarified the differences between the service packs, thats what you asked for.
Going by your first post, I could see there aren't any differences between the versions.
ProductLevel property will give the service pack that is applied, otherwise RTM if nothing applied.
But in your second post, you mentioned a different list of results. Is this what your exactly getting?
--Ramesh
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply