Files sizes in a OLE bmp field

I have a database which stores word documents into tables as BLOB fields.
I need to work out what size each WORD document is.
Do you know how can I work out the individual size of each word document?
__________
'sp_spaceused worddoc_attached' only gives me the overall size of the data
in the table.
__________
Thank you for any help in advance
JAD
You can use the datalength function to do this. You can find more
information in books online under datalength.
-Sue
On Fri, 15 Oct 2004 16:05:27 +0100, "JAD" <listgrove@.yahoo.co.uk>
wrote:

>I have a database which stores word documents into tables as BLOB fields.
>I need to work out what size each WORD document is.
>Do you know how can I work out the individual size of each word document?
>__________
>'sp_spaceused worddoc_attached' only gives me the overall size of the data
>in the table.
>__________
>
>Thank you for any help in advance
>JAD
>

file Server and Ful text indexing

Dear All,
Is it possible for SQL Server to search on documents which are not inserted
into the database?
for example does SQL Server have the facility to scan the documents, keeping
the documents in the fileserver itself and doing full-text indexing on them
taking only the token words from it. (These token words can be inserted into
database as indexes).
A similar facility is provided bu ORACLE-Text.
We are new to this area. So any hints on this would be advantageous for us.
Very thanks in anticipation.
Also please give us the utilities/tools which are readily available which
can be integrated with SQL Server / .Net Applications for database and
Documents Search.
Regards
SathianSathian,
Yes, but not using SQL Server's "full text search" components, instead you
would use the Indexing Service and create a Linked Server to IS via the
MSIDXS OLE-DB provider. See SQL Server 2000 BOL title's "OLE DB Provider for
Microsoft Indexing Service" and sp_addlinkedserver from more info on this.
Note, while this is functional, it does not perform very well.
I believe that the ORACLE Text (an expensive add-on) feature you're
refereing to is called "Oracle Ultra Search". Correct? This is another "for
fee" spider based service of ORACLE Text, that has no direct feature
comparison in SQL Server 2000 or 2005 Full Text Search, I'm to say...
If you're interested in more details, feel free to email me directly.
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian T" <sathian.t@.in.Bosch.com> wrote in message
news:d188gf$itc$1@.ns2.fe.internet.bosch.com...
> Dear All,
> Is it possible for SQL Server to search on documents which are not
inserted
> into the database?
> for example does SQL Server have the facility to scan the documents,
keeping
> the documents in the fileserver itself and doing full-text indexing on
them
> taking only the token words from it. (These token words can be inserted
into
> database as indexes).
> A similar facility is provided bu ORACLE-Text.
> We are new to this area. So any hints on this would be advantageous for
us.
> Very thanks in anticipation.
> Also please give us the utilities/tools which are readily available which
> can be integrated with SQL Server / .Net Applications for database and
> Documents Search.
> Regards
> Sathian
>