Manu Kanwarpal

Hi,

We want to create some reports(in Reporting Services) from the data in the lists in Sharepoint sites.

Is it all right to access the SQL 2005 database created by Sharepoint

I read it in some forum that it is not recommended to access that database directly. Could someone tell us why

We just want to create some views on that database.

Thanks in advance

Manu



Re: SharePoint - Development and Programming Creating a view on the sharepoint database.

Lars Haupt-Hansen

I think that as long as you only read from the database you will be fine. Use appropriate locking hints to be sure. Writing to the SharePoint database is unsupported.

You should also check Joel Olesen's post (http://blogs.msdn.com/joelo/archive/2007/10/09/ms-it-usage-and-storage-reporting-tool-released-to-codeplex.aspx) and the mentioned Codeplex project.

/Lars






Re: SharePoint - Development and Programming Creating a view on the sharepoint database.

Ryan Rogers [MSFT]

Direct, read-only access is not recommended. See the KB Article 841057 [http://support.microsoft.com/ id=841057] about making changes to the SharePoint databases, which also includes the following note (near the very bottom of the article):

"In addition to the items previously mentioned, customers are strongly advised against direct access in a read-only manner to these databases. Accessing these databases programmatically or manually could cause unexpected locking within Microsoft SQL Server that can result in overall performance problems."

HTH,

-Ryan