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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-08 : 17:56:02
|
| John writes "1) How do I tell which SP SQL is currently at?2) Why does SP3 make it to the "Updating MDAC" screen and just sit there? No processing.3) Anyone have a hammer??" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-09 : 12:29:11
|
| www.nigelrivett.comDetecting installed sql server versionDon't have v2000 sp2 - probably update the site today though.Note that if a service pack installation fails (especially on the final scripts) then this version number may still be updated.Use select @@versionto find the version numberThis will have a number which wil correspond to: 6.00.121 v6.0 6.00.124 v6.0 SP1 6.00.139 v6.0 SP2 6.00.151 v6.0 SP3 6.50.201 v6.5 6.50.213 v6.5 SP1 6.50.240 v6.5 SP2 6.50.258 v6.5 SP3 6.50.281 v6.5 SP4 6.50.415 v6.5 SP5 6.50.416 v6.5 SP5a 7.00.623 v7.0 7.00.699 v7.0 SP1 7.00.842 v7.0 SP2 7.00.961 v7.0 SP3 8.00.194 v2000 8.00.381 v2000 SP1==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-09 : 12:39:06
|
| ....annnnnnnd:8.00.534 v2000 SP2 |
|
|
|
nlocklin
Yak Posting Veteran
69 Posts |
Posted - 2002-02-09 : 14:21:10
|
| Also, the team at Microsoft is currently working on the beta of SP4 for SQL Server 7.0--"I'm always doing that. I'm always messing up some mundane detail." |
|
|
|
|
|
|
Service packs