Unable to connect to SQL Server session database the connection string was returned by an instance of the IPartitionResolver type

Today, I was playing with authentication providers for setting up the site with anonymous access.

Suddenly the site started throwing the below error. I have no clue what’s wrong on the DB Server, then I restarted the DB Server no luck L


Exception Type: System.Web.HttpException Exception Message: Unable to […]

CodePlex Release : List Search WebPart

Hi Community,

I have contributed List Search WebPart for SharePoint in CodePlex.

Project Description: This Project provides the List Search WebPart for WSS 3.0 / SharePoint 2007. Just add the WebPart to page and specify the list name, filter fields, display fields and criteria.

Simple Interface for Tool Part with advanced features for list […]

How to Create Custom Menu Item in Site Actions

The below sample feature creates new menu item in Site Actions menu, Please replace the GUID in the below code.

Sample Feature File

<?xml version=”1.0″ encoding=”utf-8″?>



Title=”Custom Menu Item”

Description=” ”

December 1st, 2009 | Tags: , , | Category: MOSS 2007 | One comment

Programmatically Retrieve List of Document Libraries

The following code snippet is used to retrieve the list of document libraries.

SPWeb _web = SPContext.Current.Web;

SPListCollection ListColl = _web.Lists;

foreach (SPList _lst in ListColl)


if (_lst.BaseTemplate == SPListTemplateType.DocumentLibrary)

November 26th, 2009 | Tags: , , | Category: MOSS 2007, SharePoint Object Model | Leave a comment

WSS 3.0 Application Templates Grouped by Business Area

If you are looking for free application template, which suites your business area, read this resource on TechNet. It has list of 40 Application templates grouped by the following business category.

Business Management/Finance Human Resources Operations/IT Project Tracking/Product Management Sales/Marketing Specialized/Verticals […]

How to Use Resource File in SharePoint 2007

Create Resource file using Visual Studio IDE

Copy the resource file into 12 hive resource folder

GetLocalized method from SPUtility to read the values from resource file


SPUtility.GetLocalizedString(“$Resources:<<ResourceFileName,ResourceKeyName>>”, “<<ResourceFileName>>”, lang);


SPUtility.GetLocalizedString(“$Resources:MyResources,FirstName”, “MyResources”, lang);

Sample Source:

November 8th, 2009 | Tags: , , | Category: MOSS 2007, SharePoint Object Model | One comment

How to Enable Document Information Panel in MOSS 2007

By Default the document information panel will not be enabled in document library.

Go to Library Settings

Click Advanced Settings

Enable allow management of content types in Advanced Settings.

Click the Document Content Type and click on Document Information Panel settings.

Check […]

Item Updating or Updated Event Occurs twice in Document Library

Item Updating or Item Updated Event in SharePoint 2007 occurs twice, if require checkout option is enabled for document library.

I found the following workaround from Microsoft Support for this issue.

Check the value of vti_sourcecontrolcheckedoutby in BeforeProperties and AfterProperties, if the both values are null then the event […]

How to Find the SharePoint Version Installed in System

To find the installed version of SharePoint in system,

Browse to Central Administration -> Operations -> Servers in Farm [Topology and Services]

Version information will be displayed for each and every server.

How to Use RSS WebPart in SharePoint

Create New WebPart Page.

In Edit Mode, Click add WebPart then select RSS Viewer WebPart from gallery.

Click Modify Shared WebPart to change to Edit mode of WebPart, then specify the RSS URL.