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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-05-11 : 22:16:19
|
| I installed SQL Server 2000 Service pack 3a (database component and analysis services component) on my SQL Server 2000. When I run select serverproperty('productversion'), it returns "8.00.760", for select serverproperty('productlevel'), it returns "SP3". Because the download files for the service pack are the same for SP3 and SP3a, I am wondering how I can make sure that what I installed was SP3a and not SP3?Thanks,delpiero |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-11 : 23:01:11
|
| You have to go by what the web page says when you download it, but MS doesn't seem to make regular SP3 available anymore, just SP3a. Be advised that SP4 was just released this past week too. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-05-11 : 23:01:54
|
| I don't think that there are any differences in the version of the SQL server executables between SP3 and SP3a. The difference is in the MDAC files and the way they are isntalled.btw, if you successfully installed SP3 then you are fine and don't need to worry about SP3a.btw, SP3a is outdated now. SP4 just came out and is probably what you should consider deploying now.-ec |
|
|
|
|
|
|
SP3 VS SP3a