Click to Rate and Give Feedback
MSDN
MSDN Library
Office Development
SDK Documentation
General Reference
 SharePoint Database Access
SharePoint Database Access

Specifies any addition, modification, or deletion of the data within any SharePoint database by using database access commands. This includes bulk loading of data into a database, exporting data, or directly querying or modifying data.

Real World Example

A list aggregation Web Part that pulls information from a variety of sites in a server farm is designed to directly query the SharePoint database for information and present it to a user.

Technical Details

Directly querying or modifying the database can place extra load on a server, or can expose information to users in a way that violates security policies or personal information management policies. If server-side code must query data, then the process for acquiring that data should be through the built-in SharePoint object model, and not by using any type of query to the database. Client-side code that must modify or query data in SharePoint Products and Technologies can do this by using calls to the built-in SharePoint Web services that in turn call the object model.

Support Details

Important:

This type of customization is not supported.

Direct modification of the SharePoint database or its data is not recommended because it puts the environment in an unsupported state.

If a server component requires information from the database, it must get that data by using the appropriate items in the SharePoint object model, and not by trying to get the items from the data structures in the database through some query mechanism.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Support for changes to the SharePoint databases      duray   |   Edit   |  

Support for changes to the databases that are used by Office server products and by Windows SharePoint Services

http://support.microsoft.com/kb/841057/en-us

Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker