Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-28 : 09:36:38
|
Jonathan Hodgson writes "Very strange question, so I'll start with a bit of background.
We have about 2gb of documents and want to give access to these from a cluster of web servers on the Internet.
Because the web servers are internet facing the only ports open to the database is the sql port (normally 1433) for ADODB.
We don't want to store all the documents as blobs in the database, mainly because:
1. Hard to manage, compared to the filesystem.
2. We need to be able to run an indexing search engine on the "real" physical files and would prefer not to have multiple copies.
The idea of having the documents on each web servers is not possible, due to speed of replication.
* So the question,
is it possible to create an extended stored procedure to return the document (~1-5mb) as a image field but get the data on the fly from the filesystem?
psedocode -
proc_getDoc(DocID)
{
@blob IMAGE
@blob = ActiveXObjectFromReturnsByteArrayOfFileFromNTFS(DocID)
SELECT retval = @blob
}
SQL Server 2000 and Windows 2000 Advanced Server" |
|
|
|
|
|
Stored procedures blobs from the file system