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?You can store documents in the text or image data type.
You probably can't search on them, but your could store a summary in a character-based field with the record, or a column that just contains keywords.
Yes, you can provide functionality similar to a file-server...you just have to write it all yourself. :(
I can tell you that you are looking at a daunting project here that will likely involve complex coding. The user-interface will probably also prove difficult.
Perhaps somebody else on the forum will see this post and could recommend some professionally designed 3rd party software for document management?
blindman
| |
No comments:
Post a Comment