Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2007-02-14 : 19:41:05
|
| hello all,If i run select serverproperty('productlevel') on my server, i got the result SP4, however if i run select @@version then the result is as below (showing the service Pack 1 instead of SP4Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Can anyone please explain why? - . THanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-14 : 19:42:19
|
| Service Pack 1 in @@VERSION is the service pack level of your OS not SQL Server. The part that shows that you are in fact on sp4 is the 2039 (8.00.2039).2039 is sp4.Tara Kizer |
 |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2007-02-14 : 19:54:16
|
| Thanks for your quick response.tocroi. |
|
|
|
|
|
|
serverproperty('productlevel')