Thanks a lot! Things are much clearer.

Thanks, all. Managed to get it done.

Backed up database, backed up transaction log, truncated the log then ran shrinkfile on the log.

Worked a treat.

Once again, thanks to everyone.

Thanks Ian,

I suspected as much (about the capped log size).

I'll give the BACKUP LOG function a try.

Once again, thanks for your time.

Thanks guys.

Thanks too jpipes. Think that would work too.

I just figured this out and it seems to work, this is what I've done:

....Get the field names into a rs as...

Hey, thanks for that.

I see what your're doing there. This is where I'm up to at the moment:

EXEC( 'SELECT ' + @FieldName + ' AS RetrievedValue FROM Jobs...

Speedy replies - thanks guys, I'll try it out.