Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-31
2
Medium Priority
?
618 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

719 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