Storing Tiff and PDF images in SQL Server 2000

Is it possible to store Tiff images and PDF files in SQL Server.  If it is then how do you go about doing so.
Who is Participating?
It is, you'd put them in an image type column.

However, it's beeter and simpler to stored a path\filename for them, and store the files on your disk.

NTFS for files, SQL for data ;)
Aneesh RetnakaranDatabase AdministratorCommented:
You need to read those files as binary from your application and store it in a VARBINARY(MAX)  column
Gonna be smaill images in a varbinary...

varbinary [ ( n ) ]

Variable-length binary data of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length of the data entered + 4 bytes, not n bytes. The data entered can be 0 bytes in length. The SQL-92 synonym for varbinary is binary varying.

thomashospitalAuthor Commented:
Decided not to put in SQL because the cons out weight the pros
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.