Thanks! I actually did go back thru and alter my proc to change the name, just for sanitys sake if nothing else.

Guess I'm still left with trying to solve...

Still cant get around not declaring @oldimage as image in your example.

I tried the following addition;

INSERT INTO

SketchTable

(

intMasterAcctID,

intBuildingID,

imgSketch

)

VALUES

(

@intMasterAcctID,

@intBuildingID,

(Select imgSketch from SketchTable where intMasterAcctID=@intOldMasterAcctID and intBuildingID=@intOldbuildingID)

GO

error received:

Server: Msg 1046, Level 15,...

I'd look at Bill Wunder's DDL Archive Utility.

http://home.attbi.com/~bwunder/archive_installation.html

Awesome little utility that I was able to integrate into source safe with very little problems. I have it set...

I've played with storing images in the database before in SQL2K. I basically have a web application that allows the user to select the image to load into the...

hi there,

I figured that I would do the backup method. Backing up and restoring a 1.2gb database takes maybe a minute so that is going to be much quicker...