How do I ouput a file to my local machine NOT the server?

• doplussee

  SSC-Addicted

  Points: 446

  More actions

  December 10, 2008 at 12:15 pm

  #202755

  Greetings.

  I have sprocs that output to files on my local drive using using the OLE functionality (sp_OAMethod).

  This all worked fine and dandy when the DB was on my local machine. As soon as I moved it to the server, connected to the server from my local machine, and ran the sprocs, it output the files to the c: drive of the server! How can I force it to output to my local machine, when running the connected to the db remotely?

  Thanks.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  December 10, 2008 at 12:29 pm

  #910608

  Use a UNC path and share a folder on your machine so the server can see it.