Image storing

How do i store an image in the db?

I guess i have to chose image as the type of the column.

Do i really need to build an application that will fetch the image and put it in a query?

or can i use directly use sql server management studio?

thanks,If you are on SQLServer2005 you should better choose VARBINARY(MAX), IMAGE and Text will be deprecated in the future. YOu have to use an application which will convert the physical file to the actual byte array.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens Suessmeyer wrote:

If you are on SQLServer2005 you should better choose VARBINARY(MAX), IMAGE and Text will be deprecated in the future. YOu have to use an application which will convert the physical file to the actual byte array.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Do you know an application that will convert the file to actual byte? or i have to code it ?|||Hi,

thats realllllyy easy, have a look at this snippet:

http://www.codeproject.com/aspnet/PicManager.asp

HTH; jens SUessmeyer.

http://www.sqlserver2005.de

IIS Install

Hi All,
I am installing SQL 2005 and would like to know if there the reporting
services are the only thing in SQL that requires IIS. So I guess my
question is if I shutdown IIS on the box what will break? Thanks
-DavidDude , you are not trying to do something right !!, Just kidding.
Nothing happens because your frontend ie RM wont work otherwise everything
is intact. since it stores in report database.
Amarnath
"damccumb@.gmail.com" wrote:
> Hi All,
> I am installing SQL 2005 and would like to know if there the reporting
> services are the only thing in SQL that requires IIS. So I guess my
> question is if I shutdown IIS on the box what will break? Thanks
> -David
>