Today onwards on daily basis, I decided to post the Sql Query to access the SharePoint Databases. To know more about the databases in Sharepoint , check my SharePoint Databases Post. To retrieve all lists from the database, use the following query, select AllLists.tp_Title as ‘List Title’,webs.Title as ‘Web Title’ from dbo.AllLists as AllLists inner [...]

Read more →