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 |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2007-03-05 : 17:15:56
|
| How can you find out if Service Pack 1 (SP1) has been installed already or not?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-05 : 17:19:43
|
| SELECT @@VERSION2047 is 2005 sp1.Tara Kizer |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-03-05 : 17:27:55
|
| Are you talking about the build?9.00.1399.06If so, that would be PRE-SP1, right?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-03-05 : 17:30:29
|
| Nevermind my last... :(It returned:"Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) "However it is showing me that Build 3790 is service pack 1. Hmmm...- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-05 : 17:32:26
|
| 3790 is for the operating system, not SQL Server. The part I was talking about is this:9.00.13991399 is less than 2047, so you are not running service pack 1. BTW, service pack 2 was released recently, so you should start working towards that instead of sp1.Tara Kizer |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-03-05 : 17:36:20
|
| The SQL version you are running is the 9.00.1399.06....that's pre-sp1.You can also try running the following script:SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-03-06 : 09:25:39
|
| Yippee! SP1 was giving me install errors with one of the required sections, but SP2 went off without a hitch! Thanks everyone.9.00.3042.00- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
|
|
|
|
How do you know if SP1 is installed?