August 2008 - Posts

With the release of SQL 2008 Express I thought it would be helpful to add a note that it you try to use the ExpressMaint utility to perform database maintenance operations against SQL Server 2008 on a computer which has never had SQL Server 2005 installed you will encounter an error. This is because ExpressMaint references the SQL 2005 SMO assemblies. In order for it to work correctly, simply install the SMO 2005 redistributable on the SQL Server 2008 computer and apply at least SQL 2005 Post SP2 Cumulative Update 5. I am currently working on a new version that will remove the SMO dependency and support all versions from SQL Server 2000 upwards as well as adding a new graphical UI and the concept of packages (think maintenance plans) to help simply maintenance operations. Download links below


Posted by sqldbatips | with no comments
Filed under: ,

A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 ( and Vista ( This release adds a fix for duplicate SSIS services when both SQL 2005 and SQL 2008 are installed. Note that it is fully compatible with SQL 2008 but the name will stay the same.


Posted by sqldbatips | 1 comment(s)
Filed under: ,

Having successfully installed SQL 2008 on my laptop I was looking forward to a smooth install on my main PC however it was not to be. Having gotten pretty much to the end of setup it failed on the SQL 2005 Express Tools rule. Now I know I've never installed SSMS Express on this PC so I went digging through the logs. Once of the nice features of setup is an html log showing the results of all the checks carried out. In this case it merely confirmed that setup thought I had the Express Tools installed as shown below

After digging through the log files I came across one called Detail.txt which has details of the rules being run by setup. As can be seen from the log below, it was checking for the presence of the SQL Express Tools by querying the registry key SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

Slp: Initializing rule      : SQL Server 2005 Express tools
Slp: Rule applied features  : SSMS;Adv_SSMS
Slp: Rule is will be executed  : True
Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.Sql2005SsmsExpressFacet
Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
Slp: Sco: Attempting to open registry subkey
Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM
Slp: Rule 'Sql2005SsmsExpressFacet' detection result: SQL 2005 Ssms EE installed=True
Slp: Evaluating rule        : Sql2005SsmsExpressFacet
Slp: Rule evaluation done   : Failed
Slp: Rule evaluation message: The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.

Checking the registry I find that the key does indeed exist and in fact was added by the install of Redgate SQL Prompt 3.5 as shown below


Uninstalling SQL Prompt allowed the SQL 2008 installation to complete successfully (another option would probably have been to export the ShellSEM key, delete it, install SQL 2008 and then restore it).

So the lesson is, if you are getting tripped up by the Express Tools check and are sure you've never installed them, check the registry to see if some SSMS addin has added the key that setup is checking for.

Update Please note that this issue is only caused by older versions of SQL Prompt. If you have upgraded to SQL Prompt 3.9 you won't be affected by this issue. This is a free upgrade for users of SQL Prompt 3.x and is available from Redgate here with full support for SQL 2008

Posted by sqldbatips | 15 comment(s)
Filed under: ,

The basic version of SQL 2008 Express is not available for download, the other editions (SQL 2008 Express with Tools and SQL 2008 Express with Advanced Services) are coming soon. Don't forget you will need to have installed .NET 3.5 SP1 and Windows Installer 4.5 before installing SQL 2008 Express. Download links below


Posted by sqldbatips | with no comments

As mentioned in a previous post, parts of SQL 2008 require you to have Visual Studio 2008 SP1 RTM installed if you had previously installed Visual Studio 2008 prior to installing SQL 2008. Today, Visual Studio 2008 Service Pack 1 RTM is available for download so no more execuses for not installing SQL 2008! There is an excellent post by Bob Ward on the PSS SQL Engineers blog explaining all the various permutations of SQL 2008/VS 2008 here

Download links below



Posted by sqldbatips | with no comments

As you may have already seen elsewhere, SQL 2008 was released to manufacturing yesterday. View the official press release here. The good news is that all the editions except Express are available for download right now if you have an MSDN subscription (be warned each edition contains the x86,x64 and IA64 versions so they are 3 GB!). Happy downloading and congratulations to the whole SQL Team for shipping SQL 2008.

If you don't have a Technet or MSDN subscription you can download the 180 Day Trial Version here

Update Visual Studio 2008 SP1 RTM is now available (download links here)

Note Because parts of SQL 2008 requires VS 2008 SP1 (which has not yet been released) if you have VS 2008 installed you may encounter some issues during setup as explained in KB 956139. Since I have VS 2008 installed on all my normal PC's I'll be sticking with VM's for SQL 2008 until VS 2008 SP1 is released. For server installations this issue won't be a problem.

Posted by sqldbatips | 1 comment(s)
Filed under: ,

A new feature pack (August) is now available for the RTM release of SQL 2008. This allows you to download redistributable components of SQL 2008, add-on providers and backwards compatability components. No Report Builder 2.0 yet though


Posted by sqldbatips | 1 comment(s)
Filed under: , ,