Further to solution 2
There is an
image
datatype in SQL 2008 that you might come across -
don't be tempted to use it -
see why here[
^].
VarBinary(MAX)
is the better solution.
You might also find this article useful
Storing Images and BLOB files in sql server[
^] - it targets earlier versions of sql server but also links to storing of blobs using
FILESTREAM
in SQL 2008.
If however, you are just intending to store a link to the file on your database then use
nvarchar