>I have mugshot photos I want to store in a datatable along with the persons profile. Previously I have only stored the url to the photo so not sure what is the proper column type etc. I know there is an Image type, but is it that simple? I would love any advice for this or advice to not do it.
>Thanks
>Tim

Not directly related to your question, but take a look here too http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/3ccb5c86-ac06-4454-8334-9ba8f74279ee