>>>>@All,
>>>>
>>>>We are investigating whether it would be possible to return a file somewhere that the SQL server service has access to by calling a stored procedure.
>>>>We do not want to store the file itself in the database, but we want to return and store the through simple calls through ODBC.
>>>>
>>>>Is there anything like that possible ? Wihtout using CLR ?
>>>>
>>>>Walter,
>>>
>>>Perhaps this can be of help: https://www.mssqltips.com/sqlservertip/1643/using-openrowset-to-read-large-files-into-sql-server/
>>
>>Its interesting for reading files, but how to write them?
>
>Hum. http://kbase.icbconsulting.com/sql-server/create-text-files-from-sql-server-data (disclaimer: just googling around...).

We need to write binary files. I know there are several ways. I forgot to ask, what the best way is to write binary files with the least impact on restrictions such as having to use CLR and having to have admin rights