Prev: non latin characters in nvarchar
Next: SQL Server on Hyper-V: Disk Configuration Best Practices
From: Dean on 7 Jun 2010 09:54
Is it possible to write a file from SQL server to a UNC path. I am working
with a dba to change a process. Currently the DBA creates a file with SQL on
the server running SQL Server and writes the file to a local directory on the
server. I then have a scheduled task that moves the file to a file share on
another server. I was wondering if it is possible to have the file written
directly to the server using a UNC path eliminating the need for the
scheduled task. Thanks
From: Tom Moreau on 7 Jun 2010 10:11
Yes, you can. Make sure SQL Server is running under a domain account and
that the account has read/write privileges on the share.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Dean" <Dean(a)discussions.microsoft.com> wrote in message
news:14814ABF-AC23-428E-9B29-D698FCA50869(a)microsoft.com...
Is it possible to write a file from SQL server to a UNC path. I am working
with a dba to change a process. Currently the DBA creates a file with SQL on
the server running SQL Server and writes the file to a local directory on
the
server. I then have a scheduled task that moves the file to a file share on
another server. I was wondering if it is possible to have the file written
directly to the server using a UNC path eliminating the need for the
scheduled task. Thanks

 | 
Pages: 1
Prev: non latin characters in nvarchar
Next: SQL Server on Hyper-V: Disk Configuration Best Practices