>

Some part of your SQL statement is nested too deeply – Versioning limitation in SharePoint 2007

Aparently there is a versioning limitation in SharePoint, where if you enable verisioning settings for any kind of a document library, sharepoint will limit the number of versions to exist with the number 255. Once the limit the reached SharePoint appa…

Search Crawl Warning – Some parts of this document cannot be accessed

Reasons and fix for the issue are listed below

It was observed that the search crawler has logged the following warning message, “Some parts of this document cannot be accessed”
It was found upon that this message is displayed for the types of con…

List item query elapsed time error in MOSS 2007

I encountered this log when I was fixing the performance issues in a project. Upon further analysis, I came to know that the code was trying to access a list, but the thing is that the code was invoked from the Master Page. Ultimately when this piece o…

Creating custom list instances using the WSP builder

The wsp builder is a plug-in that adds a template in the visual studio. This tool can be download from the following link,
http://wspbuilder.codeplex.com/releases/view/16820
The following are the steps for creating a solution package for list instance …

Unable to open the physical file. Operating system error 5: (Access is denied ) – After SharePoint database move

 
After you move a sharepoint database or relocate a sharepoint content database you may encounter the above mentioned error, where in it says that the access is denied for the current user.
The workaround that I did was to go the physical location of…

Creating custom list definitions MOSS 2007 using the Solution Generator 2008

The solution generator can be used to create list definitions and deployment package for the same.
Steps to create a solution package for a list defintion,
Open the Solution Generator,
Select the list definition option and click next,

Select the &#822…

Programmatically setting the moderation status or Approval status of a folder in the Pages library

The code for programmatically setting the moderation status to Approval for folders created in the publising pages library is as follows, it is assumed that the folder is being created already. Setting the folder approval status is vital as otherwise t…

Create a custom folder in the Page Library of SharePoint Publishing template

Sharepoint by default does not allow creating folders in the Pages library. Folders can be created using the explorer view in the Page Library and another is using  custom development, by using a tool. The code for creating a folder in the Pages lib…

Item level permissions – Removing a particular user or group

Item level permissions are implemented as per the business flow. It can be implemented in SharePoint 2007 either by implementing it as an event handler or a workflow.
Depending on whichever way of implementation the following code segment can be used t…

Search Crawl Error – Error in the site data web service (Exception of type ‘System.OutOfMemoryException’ was thrown.)

Reasons as to when you may encounter this issue,

It was observed that the document libraries and the lists use multiple content types which are not used by the system and thereby causing redundancy in data.
Multiple content types in a list or a docume…