I have some data in varbinary(max) from database and I have exported it to physical files. Some of these files were in jpeg so I was able to just add an extension .jpg to it and it opened. The rest are not jpeg files.
I have tried almost all the expected extensions from doc to pdf but none worked. I used UltraEdit to identify the "magic numbers" of the file so I can compare them to the ones found here: