Porting SQL IMAGE to VARBINARY(MAX)

From tekkies.co.uk
Jump to: navigation, search

You may be looking to change a column from data type IMAGE to VARBINARY(MAX) in MSSQL2008.

Here is something you should be aware of:

"Partial updates are not supported on columns that have a FILESTREAM as a source."

You will get the above error message if you try something like the statement below in SQL2008

UPDATE [tbl_MDA_Media] set [Media] .WRITE(0x1a5175616...4757778797a828384, 512, 512) , LastModified = '2013-06-26 11:12:00' where [MediaID] = '7724'