June 13, 2008 at 1:07 pm
hi i am running:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and i get
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
is this service pack 2 for sql server? if not, is there any issues downloading service pack 2 for sql server 2005??
June 13, 2008 at 1:46 pm
run this query instead
SELECT
SERVERPROPERTY('productversion') "version",
SERVERPROPERTY ('productlevel') "service pack",
SERVERPROPERTY ('edition') "edition"
Always suggest testing before installing a SP. So if you have a test server, do that first.
If you cannot test, at least get full backups of all your databases and agent jobs.
//EDIT-
I see that's the query you listed as already running, which does not give that output you listed.
You have RTM btw, http://support.microsoft.com/kb/321185
June 13, 2008 at 1:53 pm
I don't think so - sorry I'm beyond sp2 and I'd advise you to go to at least sp2 + cu5 or cu6 - there are some memory bugs in sp2, amongst others. cu5 is 3215 I think - I'd say that would be the minimum you should be running.
There's a number of web sites which give all the versions but I don't have them bookmarked at home.
I personally haven't had any problems applying sp2 or the updates, I've had problems with sp2 but that was fixed in the updates.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 17, 2008 at 11:48 am
Thank you all! i upgraded to sp2 successfully. 😀
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply