EDIT: new version of stored procedure is located here. Use the new version for 2005/2008. Use the below version for 2000.
I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server databases. In this version, I fixed two bug and added a feature. Here are the changes:
Fixed "2000 backupset" bug by qualifying the object to msdb.dbo.backupset
Fixed the full backup check for SIMPLE recovery model databases (bug found by Eugene from PerfSpot.com)
Added Red Gate SQL Backup functionality
If you have scheduled jobs...