sql server programming: @@version v serverproperty('ProductLevel') -- sql server programming

Re: @@version v serverproperty('ProductLevel')

Dan Guzman
11/2/2007 8:53:40 AM

sql server programming: [quoted text, click to view]

Note that the Service Pack reported in the version string is the OS service
pack level, not the SQL Server SP level.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]

@@version v serverproperty('ProductLevel')

Paddy
11/2/2007 1:30:13 PM

I am trying to figure out which Sp my inherited server is on in sql
2005.

select @@version gives
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

where as

select serverproperty('ProductLevel')

gives
-------------------------------------------------------------------------------------------------------------------
RTM

--
So my question is question is how do I decide which is correct?

Re: @@version v serverproperty('ProductLevel')

Bulent
11/2/2007 1:38:05 PM

[quoted text, click to view]
--=AD----------------------------------------------------------------------=
-----=AD-------------------------------------------------------------------=
--------=AD-------------------------------
[quoted text, click to view]

Actualy both are correct. Check out the link below.

http://support.microsoft.com/kb/321185

Good day...

Re: @@version v serverproperty('ProductLevel')

Paddy
11/2/2007 1:51:09 PM

Thanks Bulent

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.