Re: Documents in SQL Server

From: Bil Simser [MVP] (bsimser_at_shaw.ca)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 17:22:26 -0600

The document itself is in a binary field called Content (I think that's the
name). You would need to use a SqlBinary reader or something in a .NET
application to extract it and write it out to disk (I don't think there are
any tools in SQL or Query Analyzer to do this). 

-- 
-Bil
http://weblogs.asp.net/bsimser
"nancyk" <nancy.kempf@neudesic.com> wrote in message 
news:%23wkQwc9rEHA.3452@TK2MSFTNGP09.phx.gbl...
> update -- I see metadata in the Docs table, but have not located the 
> actual document in sql. Thanks
> "nancyk" <nancy.kempf@neudesic.com> wrote in message 
> news:ee3S%23F9rEHA.1016@TK2MSFTNGP10.phx.gbl...
>> For documents stored in both Portal and Site level document libraries, 
>> which databases and tables contain these documents and their associated 
>> metadata?
>>
>> thanks
>>
>
>

Relevant Pages

  • Re: Documents in SQL Server
    ... update -- I see metadata in the Docs table, but have not located the actual ... document in sql. ... "nancyk" wrote in message ... > which databases and tables contain these documents and their associated ...
    (microsoft.public.sharepoint.portalserver)
  • Re: OT: why do web BBSs and blogs get so slow?
    ... As a result I've poked around in the Slashdot SQL ... the list of stories itself, but there are also lists of subsections (Apache, ... > be a fixed length of metadata for each message, ...
    (comp.lang.python)
  • Re: Which one is faster: IMAP server or MySQL server?
    ... I see it has a comment about Zimbra storing metadata to SQL and message ... actually more about metadata than bodies. ... Implementing a well performing IMAP server is mostly about minimizing ...
    (comp.mail.imap)
  • RE: Importing several text file into several tables
    ... Are you using SQL 2000 and DTS? ... How would you handle it if you package only processed one single ... I have many text files on a folder with the same metadata and I need to ... (the format of the files is not known but they have the same format) ...
    (microsoft.public.sqlserver.dts)
  • Re: elegent way to handle "pluggable" backend servers?
    ... For most selects it isn't that hard to turn metadata ... about the query into vendor SQL. ... That can easily be shoved into a single factory ... The handler classes all implement a few hooks like ...
    (perl.dbi.users)