• vinu512 (8/24/2014)


    LutzM (8/24/2014)


    What permission does the user have who's running that code?

    Based on MS Technet

    Only members of the sysadmin fixed server role can execute sp_OASetProperty.

    If you're not a member of the sysadmin role, this might be the reason for not creating the file.

    As I mentioned earlier, I am using the admin account on my Lappy.

    And I am logged into sql server using Windows Authentication.

    And I do have the sys admin role checked for this login.

    This is not a question about your credentials on the box but the SQL server's, don't think that process is running as admin.

    😎