home articles news code blog links search

		expressmaint TSQL Author  Jasper Smith Created  31-07-2004 Updated  28-07-2008 Requests  851 Description Since SQL Server 2005 Express Edition does not come with the sqlmaint utility or anything like it, this code demonstrates how to write a TSQL equivalent. It allows for Full, Differential and Log backups of specific databases or all user or system databases, Index Rebuilding or Reorganization and Database Integrity checks with full reporting and old backup/report housekeeping. Revision History Author Date Description Jasper Smith 31-07-2004 Initial Creation View Code Download Code

© Copyright sqldbatips Ltd 2008. Contact webmaster

home | news | articles | code | blog | links | search