Jason
Jason

Reputation: 77

Store pdf files in sql server

What data type should I use if I want to store pdf (1mb-20mb) files? Im using sql server 2008 enterprise edition.

Upvotes: 2

Views: 3322

Answers (1)

lunixbochs
lunixbochs

Reputation: 22415

You're looking for FILESTREAM. It stores large BLOB data as actual files, which prevents them from affecting the database performance.

Upvotes: 3

Related Questions