How find info regarding MOSS 2007 metadata

Sharepoint_config database stores metadata information related to sharepoint websites and content.  While I did my own digging through the tables i found the below SQL statement from Bert Van Landeghem's blog:

SELECT [Id]

,[ClassId]
,[ParentId]

,[Name]

,[Status]

,[Version]

,[Properties]

FROM [Sharepoint_Config].[dbo].[Objects]

WHERE properties LIKE '

BI Thoughts and Theories » Blog Archive » View Permissions for Reporting Services in SharePoint Integrated Mode

BI Thoughts and Theories » Blog Archive » View Permissions for Reporting Services in SharePoint Integrated Mode: "You simply need to ‘Publish a Major Version’ of the item in SharePoint with the context menu in the library. Once you do this the users no longer need the edit capabilities and you can follow the security here – http://msdn.microsoft.com/en-us/library/bb283148.aspx. If you don’t publish a major version then the only way the end-users will see the items is if they have the edit items permission which is something that you definitely do not want to provide them."

The Permission granted to user DOMAIN\UserName is insufficient for performing this operation.(rsAccessDenied)

Found this link and seems to be logical and interesting solution to the problem.  But I could not figure out the approval part for data sources.  Could not find the option.

Permission to reports in Sharepoint integrated mode.

Update:  The option to approve a data source appears if a subsite is created and data connection library exists under this subsite.  I am not sure why it should not show up under default website.

Sharepoint Enabling Usage Analysis and Importing data

Usage analysis in Sharepoint 2007 can be enabled by navigating to Central Admin -> Operations -> under Logging and Reporting -> Usage Analysis processing.

Check the Logging Setting's,  Enabling Logging box.
Set the time when want the log needs to be processed under Processing Settings.
Note :  The log generation job is daily job and only runs once in a day.

Once set you would need to wait for a day to get the generated log file.  The log file is generated under
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\.  The web application GUID can be extracted by connecting to Sharepoint_Config Database and running the following query.


select o.id,, o.* from objects o
inner join Classes c on c.Id = o.ClassId and c.FullName like '%SPWebApplication%'
where o.name like

If your sharepoint infrastructure on configured in a farm then each server on the farm generates its own log.  you would need to search for the web application guid folder and the folder for each day to view the log.

Use Javascript to open URL in SSRS report using action

="javascript:void(window.open('http://xxxxx/Dashboards/Supply%20Chain%20-%20Help%20Desk/Top%2010%20Analysis.aspx','_blank'))"

Access Denied error while trying to Preview SSRS Report

You might get a message "An error occurred during local report processing. Access Denied. (Exception from HRESULT: 0x80030005 (STG_E_ACCESSDENIED))" while you try to preview a report you developed under VS 2008 and which has been added to TFS or any source control.  

The reason for this is due to the .data file associated to the report which is read only state. You can resolve this issue by either checking out the .data file or unchecking the readonly attribute of the file under local folder.

Here is a nice article post by about the issue 

http://ddkonline.blogspot.com/2009/07/fix-sql-reporting-services-2008-error.html

Having JPG format in SSRS export dropdown

Append the below xml emlement to reportserver.config file under element.

<Extension Name="JPG" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering">
     <OverrideNames/>
         <Name Language="en-us">JPG</Name>
     </OverrideNames>
     <Configuration>
        <DeviceInfo>
             <OutputFormat>JPEG</OutputFormat>
        </DeviceInfo>
     </Configuration>
</Extension>