Just my 2 cents...

Lot's of folks create a PK or Unique index with the IGNORE DUPES setting turned on.  Whether that's true or not, I've found that having a key...

Know of any URL's that'll get Nali started on that, Steve?  I thought I had a good one but can't find it, now...

And then, what?  You will still have problems getting the images out of the DB to be displayed.  Perhaps this will change your mind... there are hundreds more like it...

And, what permissions do you have when you login?

Yes... it's a known fault and a chronic complaint we all have... the simple thing to do is to always remember to do a {Ctrl=A} to select everything in the...

Oh Jeez... the simplicity of your solution is even more proof of your genius... I'm a bit ashamed that I didn't figure it out on my own... much like "SQL...

You, Sir, are not only a genius, but you've made my day... I tested it and that is precisely what I was looking for!

I've gotta ask, David... how in the...

David,

Seems a bit complex in light of Jan's second solution.  What was wrong with it?

Undocumented "feature"?  So what would SET @Counter = @Counter+1 be?

Hi Mike...

Perhaps this will help... do read the comments... you'll figure how to use it... could turn it into a table variable function, I suppose...

USE Master

GO

CREATE PROCEDURE dbo.sp_GetDirectoryFileInfo

/****************************************************************************************

 PURPOSE:

 This...

You can also call it from xp_CmdShell.

But, what does the VBScript you want to execute actually do?  Lot's of folks overlook the power built into SQL Server and try to...

Yep... do a backup.

You shouldn't... you should store the file name only and let the external app get the file using the file name.

You still haven't told us, Janet... why do you need to do such a thing?  Might lead to something even "cooler" if we knew...

>>Or did I misunderstand what's going on?

Just a bit, Scott... the OSQL would be executed by a scheduled "DOS Batch" process... not from SQL... that would make the SPIDs match...