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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-08-26 : 10:47:53
|
| How do I verify the SQL Server service pack versions installed on the desktop clients? From within EM if I choose HELP - About Microsoft SQL Server Enterprise Manager all I see is version 8.0, however I know sp3a was applied to this specific PC. Should I be looking at the information under Microsoft Management Console?Thanks, Dave |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-26 : 10:50:58
|
| In Query Analyser Run thisSelect @@VersionYou can see Service pack information alsoMadhivananFailing to plan is Planning to fail |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-26 : 11:53:37
|
| select @@version will just tell you about the server, I think the question is regarding the client tools.You can verify their versions from looking at the files in the filesystem. You can look in Program Files\Microsoft SQL Server\80\Tools\Binn and check the versions of your DLLs or isqlw. if you are running SP3a they should all be around 2000.80.818. If you have installed SP4 they will be 2000.80.2039.This stuff can be more easily verified if you use a software inventory tool like SMS or something similar. -ec |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-08-26 : 12:01:28
|
| Thanks ec |
|
|
|
|
|
|
How to verify sp version on clients?