Filestream is the most efficient way to store unstructured data, and is available since 2008
You need to enable filestream for the database and add a filestream filegroup.
Alter the table column to varbinary.
See the below links
http://msdn.microsoft.com/en-us/library/gg471497.aspx
http://msdn.microsoft.com/en-us/library/cc645923.aspx
http://msdn.microsoft.com/en-us/library/cc645585.aspx
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]