Solved

sharepoint documents library where is the file saved in the sharepoint database

Posted on 2010-08-31
2
561 Views
Last Modified: 2012-05-10
sharepoint documents library. what table and column is the file saved to in the sharepoint wss_Content database?

Thanks!
0
Comment
Question by:cstratton
2 Comments
 
LVL 10

Expert Comment

by:shahzadbux
ID: 33568723
found this http://msdn.microsoft.com/en-us/library/bb931737(v=office.12).aspx

not sure if it applies to your version of sharepoint.

would add that its not recommended (or supported) by microsoft to make changes to the db directly!
0
 

Accepted Solution

by:
cstratton earned 0 total points
ID: 33569198
thanks, I found a solution that works for me.

Sharepoint Server 2007

--content contains the file
select DirName,LeafName,nvarchar7 as Title,MetaInfo as Content
from docs
join DocStreams
on Docs.SiteId = DocStreams.SiteId
and Docs.Id = DocStreams.Id
Join UserData
on Docs.SiteId = UserData.tp_SiteId
and Docs.DirName = UserData.tp_DirName
and Docs.LeafName = UserData.tp_LeafName
where ListId = '0B9F3F3D-954D-43DF-812E-42AC49FBD610'
and LeafName not like '%.aspx' and LeafName not like '%.xsn'
and Extension <> ''
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now