Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Question

Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

So, how did things turn out?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 2

Jeff Moden (11/23/2008)
So, how did things turn out?

I am down with fever .... will definitely let you know when I will work....

Regards,
[font="Verdana"]Sqlfrenzy[/font]

Khades SSCrazy Points: 2067 More actions · Answer 3

I have created an account on these forums just to let you know how awesome you are Jeff.

Thank you for the code, not only does it work great, but it's very easy to understand and I've learned a lot from it.

DZN SSC Eights! Points: 825 More actions · Answer 4

Great Store Proc !!!

It will help me a lot.

Now, I have to access a shared drive.... not a local drive and (of course) this is not working....

Any help would be usefull.

Tks

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 5

Khades (11/5/2010)
I have created an account on these forums just to let you know how awesome you are Jeff.
Thank you for the code, not only does it work great, but it's very easy to understand and I've learned a lot from it.

Oh my. I'm truly embarassed. :blush: I lost track of this thread and didn't see your wonderful comment. My apologies and thank you very much. It's probably a whole lot too late but welcome aboard.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 6

DZN (3/15/2011)
Great Store Proc !!!
It will help me a lot.
Now, I have to access a shared drive.... not a local drive and (of course) this is not working....
Any help would be usefull.
Tks

Did you setup an actual "share" for this? IIRC, the share must be setup where the login name for the SQL Service can actually see the share.

My recommendation at this point would be to start a new thread that more people will see so you can get a better answer than my humble reply. You should also post the code that is "not working" and be a bit more descriptive as to what the symptoms of "not working" are. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Khades SSCrazy Points: 2067 More actions · Answer 7

Oh my. I'm truly embarassed. :blush: I lost track of this thread and didn't see your wonderful comment. My apologies and thank you very much. It's probably a whole lot too late but welcome aboard.

Haha, it's ok, thank you. I've enjoyed my time here so far.