Friday, February 24, 2012

Create File

Hi
Is it possible to create file on server side with sql server 2005.
lets say
I have table and PDF files stored in this table (binary)
No i want to save this file on server side to specific folder?
Best regards
MexSure as long as the SQL Server service account has the permission to do so.
Simplest example is EXEC xp_cmdshell 'dir > c:\temp\junk.txt'
Linchi
"Mex" wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
>
> Best regards
> Mex
>
>|||On Jun 15, 8:32 am, "Mex" <redivi...@.hot.ee> wrote:
> Hi
> Is it possible to create file on server side with sql server 2005.
> lets say
> I have table and PDF files stored in this table (binary)
> No i want to save this file on server side to specific folder?
> Best regards
> Mex
Sounds like a good place to use a CLR stored procedure if your app/
middle tier won't provide this.

No comments:

Post a Comment