Pack installation process, which differs quite a bit from SQL Server 2000 and SQL.

Resource database which was first introduced in SQL Server 2005.

Resource database is a read-only database that contains all the system.

However, Database Administrators should first apply the service pack on development.

Packs. If any of the rules are failing, the installation will not continue further.

Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

I dont think I could check it from the Management Studio as its a different application.

But the SQl server it self has no UI to check under about.:).

I should have mentioned that I need it for the Expression Edition.

There is already Sp2 for the express edition here: microsoft.comdownloadendetails.aspxid20610 However once downloaded I cant install it.

Do I have to select New Sql Server stand-alone installation or ad features to an existing installation The problem is, once I do that, in the window Perform a new installation or Add features to an existing instance It doesnt accept mu current instance.

Both of these versions will return SP1 for ProductLevel, and both will say Microsoft SQL Server 2008 R2 (SP1).

This was a brain-dead Microsoft naming blunder along the lines of TIMESTAMP, DATETIME2 and DACPAC.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged sql-server-express sql-server-2008-r2 or ask your own question.

Sql Server 2008 Sp1