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

  • Jeff Moden

    SSC Guru

    Points: 995703

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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

    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

    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

    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: 995703

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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: 995703

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "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

    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.

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

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