I asked this on the old board (without an answer) and don't see it here so I'm reposting it because I found an answer in case anyone else needs to do this. My issue was that I store some paths in an app config file and I wanted the user ...

I need to store email attachments, which may be an image,file, or document in sql server. Which datatype should I use for the column? would it be nvarchar(MAX)?