Jasper Smith is at it again! Noting that there wouldn't be a version of SQLMaint for Express, he wrote one for us. Sweet! Article here and source code here.
In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these utilities for backing up and maintaining your databases and how to schedule these tasks using the Scheduled Tasks facility in Windows XP and Windows 2003. In this article we will concentrate on the TSQL version of the utility which is in the form of a stored procedure - expressmaint.
Go get it!
I've been working on a demo .NET to Java, Java to .NET Web Services application for a few days now. It's not quite root canal, but its making me feel like the King of Pain all over again. Read more here