spDeleteImageFromAlbums

        CREATE PROCEDURE dbo.spDeleteImageFromAlbums
          (
          @ImageID int
          )
          AS
          BEGIN

              BEGIN TRANSACTION

              --Delete image from the album
              DELETE FROM dbo.ImageAlbum_Images WHERE SiteImageID = @ImageID

              --Remove this image from the album, if it is...
              UPDATE dbo.ImageAlbum SET AlbumArtImageID = NULL WHERE AlbumArtImageID = @ImageID

              COMMIT TRANSACTION

          END