Home Forums SQL Server 2012 SQL 2012 - General Retrieve binary file from SQL Server RE: Retrieve binary file from SQL Server
bgrossnickle
Ten Centuries
Points: 1332
More actions
April 22, 2014 at 2:45 pm
#1707915
This worked for me. I did change 'SP_CONFIGURE 'Ole Automation Procedures', 1' to 'EXEC SP_CONFIGURE 'Ole Automation Procedures', 1' and changed the SELECT statement to 'select top 1 @File = BinFile FROM Test'. I am running @@Version SQL 2008 R2.