Unanswered: Can I store a file in a SQL Server Database?
I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
Also the database where this table is created should provide similar functionality as a file server open, edit, check in, and check out on stored files. Can I do this in SQL Server 2000?