spaghettidba (5/15/2014)
snowfrost.c (5/15/2014)
Can I confirm that the file is stored in the database as binary data and the file is not being stored somewhere in the SQL server ?I suppose that you want to know whether the file contents are stored as tabular data inside the database or in the file system.
If this is your question, the image data type is stored inside the database.
In SQL Server 2008 and newer you can add the filestream attribute to varbinary(max) columns to store the binary data in the filesystem and not inside the database tables.
It is always stored in the database system (not in the file system), but not necessarily in the data pages themselves. If the contents are too large, the data row will just have a pointer to the pages where the actual string of bytes is stored.
You can control when the image is stored inside the data rows or not with sp_tableoption. (When it is bigger than the limit, it is not stored inside the actual data pages).
Anyhow, image is deprecated. Get rid of it 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP