September 26, 2011 at 1:38 pm
Hello Friends,
I've posted this in sql express fourm as well but not getting response and thats why i am posting it here..Please help.......I want to update sp4 on SQLExpress 2005 edition. Do I need to reinstall the SQL server Express edition in order to update the patch on this one? Please help me on this one.
When I go to the following link I get a couple of download options. I am not sure which one to choose.
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=184#system-requirements
File Name Size
SQLEXPR.EXE 54.0 MB Download
SQLEXPR_ADV.EXE 254.0 MB Download
SQLEXPR_TOOLKIT.EXE 224.0 MB Download
SQLEXPR32.EXE 35.0 MB Download
September 26, 2011 at 1:50 pm
From this page:
http://support.microsoft.com/kb/913089
Important notes for using Microsoft Update
•When you use Microsoft Update to install SQL Server 2005 SP4, the installation is unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
•Microsoft Update upgrades all instances of SQL Server 2005 to SQL Server 2005 SP4. For example, if you have two instances of SQL Server 2005 that are running on the computer, both instances are upgraded to SQL Server 2005 SP4.
•The SQL Server 2005 Express Edition updates are shown when you do an express scan and are available as an automatic update. The other editions of SQL Server are available as a custom update or as an optional update.
•For more information about Microsoft Update, visit the following Microsoft Web site:
So, what does that mean?
Well, the instructions, as they are, are here:
http://www.update.microsoft.com/microsoftupdate/v6/vistadefault.aspx?ln=en-us
My personal work PC has this blocked by policy. Run that in 'express' mode, and it should pop up with SP4.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 26, 2011 at 2:32 pm
Hi...Thank you for you reply…. but not sure if i understood correctly....you are saying that SQL express edition will update to SP4 automatically as soon as windows update happen? please clarify a little bit for me….Please Help
September 26, 2011 at 3:08 pm
sqlquest2575 (9/26/2011)
Hi...Thank you for you reply…. but not sure if i understood correctly....you are saying that SQL express edition will update to SP4 automatically as soon as windows update happen? please clarify a little bit for me….Please Help
It's supposed to, yes.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply