Export/Downloading to Local PC using TSQL

• JefB

  Newbie

  Points: 1

  More actions

  April 29, 2005 at 9:00 am

  #65805

  I supply reports to my clients on the internet using FrontPage and data from SQL 2000 databases.

  Is there a way to set up a stored procedure that would export the data to the local C drive of the user?

  Currently, when I specify the C drive in a stored procedure, it always goes to the C drive on the server.

  Any help would be appreciated.

  JefB

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 29, 2005 at 9:32 am

  #555989

  Ceate share drive in your client's PC and change the drive to UNC path like \\yourclientpcname\share\....

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  May 2, 2005 at 7:44 am

  #556275

  Though, don't forget that the sqlserver service also needs permissions to write to that share on the client.

  ..this all happening over the internet..? Might not be as trivial to fashion a 'good' solution once you factor in the security aspects.

  /Kenneth