May 2008 - Posts

An updated release of SQL 2005 Service Manager for Vista is now available (2.0.0.4). This release fixes a localisation issue for users running a non English language version of Windows Vista. Download links below:

 

Posted by sqldbatips | with no comments
Filed under:

It seems that the Windows Internal Database (WID) that is used by WSUS is actually a cut down version of SQL Express that does not install SMO by default (required by Expressmaint console application) and also does not support some of the sp_configure options required by the TSQL version of Expressmaint. This means that when you try and execute a backup command via the Expressmaint console application or TSQL procedure you will encounter errors. The WID instance appears to have an instance name of MICROSFT##SSEE. Due to the lack of support for required sp_configure options it is not possible to backup this edition of SQL with the TSQL procedure however it is possible to do so using the Expressmaint console application,

In order for Expressmaint to exeute properly, SMO for SQL 2005 must be installed. A standalone installer for this can be downloaded from the Feature Pack for SQL 2005 download page. SMO has a couple of dependencies that must also be installed namely Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client which can also be downloaded from the Feature Pack page. I have included the direct and indirect download links below

Posted by sqldbatips | with no comments
Filed under: