We are using an Access database with Employee Pictures.
However, we find that the size of the database is pretty
large as images are stored as BMP format in Access.

We would like to know which datatype should be used for
storing photos in SQL Server 2000 ? Does it justify for
us to upsize the backend from Access DB to SQL Server ?

Thanks

The general rule of thumb for most systems is to store the images in the O/S
file system and store a path to the file in the db table.

SQL Server would be an image datatype if you go that route

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

"Jason" <anonymous (AT) discussions (DOT) microsoft.com> wrote