Solved

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

Posted on 2010-08-31
2
573 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Loop to go backward 90 days 2 18
Inserting oldest record into new table. 5 22
SQL Improvement  ( Speed) 14 26
CPU high usage when update statistics 2 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

813 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

16 Experts available now in Live!

Get 1:1 Help Now