Store > 8 KB image as byte array in SQL Server 2008

I use NHibernate.

I do not think the error is in the code though, as when I connect the program to MySQL DB, this issue do not occur.

The datatype for image on MySQL is longblob.

I have tried the below.

EXEC sp_tableoption 'dbo.hr_person', 'large value types out of row', 1;

This script, as on MSDN site, will allow large object store outside row limit.

however, even after restart the SQL Server and rerun the program, the issue is still there.