contents of imagestorehouse, used for this project:

Sub Main()

Dim CommandLine As String = Microsoft.VisualBasic.Command()

If CommandLine.Substring(0,...

CREATE PROCEDURE procGetFile_bin

@FileSpec varchar(500) = ""

AS

SET NOCOUNT ON

IF OBJECT_ID('##tmp_table', 'U') IS NOT NULL DROP TABLE tmp_table

CREATE TABLE ##tmp_table(auton INT PRIMARY KEY IDENTITY(1,1), ImgFld image )

INSERT INTO ##tmp_table(ImgFld) VALUES(NULL)

DECLARE @Add_Str varchar(200)

SET...

Oh you are a very smart man. That will work excellently. I think. 🙂 Saves me some work too with the whole number generation and everything. I'll post the code...

Lets see if I can shed a little more light on how it works now...

Client-Side:

INSERT INTO File_Store(binData) VALUES(NULL)

@row_loc = (SELECT MAX(AutoN) FROM File_Store) (Yeah, I know that's wonky-I want to...

Exactly what its doing. 🙂 No way am I opening up a file-sharing port for external users. 😉 I feel bad enough with my (modified) SQL ports open.

I can already do what I want. But its roundabout.

I generate a unique (autonumber) column on the SQL server, with an IMAGE field (NULL). Then I call xp_cmdshell against an...