Browse by Tags

Updated build of ExpressMaint utility is now available

An updated version (1.6.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fixes Fixed error when database name contains an apostrophe Fixed error when no report file is specified...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 11-04-2008
First thing to do after installing SQL Server Management Studio 2008

One of the strangest UI design decisions in Management Studio for SQL 2008 is that by default the Start Debugging button is right next to the Execute button as shown below I myself have hit it by accident more times than I'd like to admit and I have seen many a demo (by MS staff as well) run into...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 09-10-2008
Enabling My Reports feature in Reporting Services 2008

Although most of the functionality that used to be available for managing Reporting Services from Management Studio has now been removed in SQL 2008 (I assume because research showed the majority of customers use the Report Manager web interface), enabling the "My Reports" feature has strangely...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 09-02-2008
Using Expressmaint on SQL Server 2008

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...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-19-2008
Updated Releases of SQL 2005 Service Manager now available

A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.14) and Vista (2.0.0.6). 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 to sqldbatips.com blog (Weblog) by sqldbatips on 08-15-2008
SQL 2008 Install Blocked on Express Tools but actually due to SQL Prompt

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...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-14-2008
SQL 2008 Express Edition available for download

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...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-14-2008
SQL Server 2008 RTM August Feature Pack available

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 Microsoft SQL Server 2008 Feature Pack August 2008

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 08-07-2008
Updated Release of SQL 2005 Service Manager for Vista now available

A new build of SQL 2005 Service Manager is now available for Windows Vista (2.0.0.5). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition (see why here ) Download SQL 2005 Service Manager from sqldbatips.com Download SQL...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 07-02-2008
Updated Release of SQL 2005 Service Manager now available

A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.13). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition (see why here ). Updated sourcecode is available from the Codeplex...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-30-2008

Page 1 of 2 (11 items) 1 2 Next >