Lowell - thanks for the code

I'll try to implement it later next week. I first need to skinny down the DB as I'm REAL close to that 4GB limitation...

I reorganized the indexes and the size wasn't affected. Looking deeper into the database I realised that each transaction had corresponding pictures of material in addition to ID's. ...

I finally got back to work on this deleting blobs issue. I figure I have less than a week to get it done.

My plan is to delete rows based...

Two good solutions - I'm leaning towards a table with the last run date with the max id at that time - that way I can schedule the run monthly...

Jeff - the index is clustered. I'll probably try both methods & see what kind of space savings I get. We have to keep 30 days of ID...

Lowell,

Thanks for the code. I probably won't get to try it 'til next week or so - I'll be travelling a bit, but I'll let you know how it...

What I actually need is sample code on how to either delete the selected rows or preferably how to delete the images in those rows.

Thanks,

Jim

Lowell, here goes (from MS SQL Server Management Studio Express)

USE [Images]

GO

/****** Object: Table [dbo].[tblCustomerImages] Script Date: 03/29/2010 17:26:07 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblCustomerImages](

[ImageID] [int]...

The table in question has the following columns:

ImageID

CustomerID

IDimage - blob

FaceImage - blob

I can figure out from the transactin DB the ImageID that I want as my starting point.

There are no...