Flushing Expired Session STat Data from SSP Database

To flush expired session' stat Data from SSP Database run the following script:

Use SSP
truncate table ASPStateTempSessions

Infrastructure Planning and Design

A good set of Infrstucture planning and design downloads. Click here....

When we try to install AX 2009 SP1 Reporting Services on a PC running SQL 2008,we get an error saying that MSSQL 2005 SP2 is required.

Thanks to Arjit Basu the following is the instructions on his blog.http://daxguy.blogspot.com/

1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder
[\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52]
2. Extract the AX 2009 .iso to a shared folder
3. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder:
\\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50\Setup
\\DynamicsAX\Msi\Components64\Program Files\Microsoft Dynamics AX\50\Setup
4. It will ask to replace the existing dll having File Version - 5.0.593.0. Say Yes and replace.
5. Then Install AX Reporting Services extensions. It works fine and the Reporting Extensions are installed nice.

Visual Studio Extensions for Windows SharePoint Services on a 64-bit machine

The below blog has a link to download a 64 bit version of visual studio extensions for sharepoint.

http://bloggingabout.net/blogs/harold/archive/2008/12/02/installing-visual-studio-extensions-for-windows-sharepoint-services-on-64-bit-machines.aspx

Unit Testing in Sharepoint

Typemock are offering their new product for unit testing SharePoint called Isolator For SharePoint, for a special introduction price. it is the only tool that allows you to unit test SharePoint without a SharePoint server. To learn more click here.
The first 50 bloggers who blog this text in their blog and tell us about it, will get a Full Isolator license, Free. for rules and info click here.

How to get physical path of 12 in code.

//use reference to below
using System.Web;


string strPAthTo12hive =HttpContext.Current.Server.MapPath(@"~\_layouts/1033/PurchaseLinks.js");

Infopath form closes as soon as you open it in sharepoint workflows.

I had a strange error as soon as a VS 2005 workflow that I wrote for Sharepoint would try open an InfoPath form it would close without giving any errors. The only error was the following in the logs: EventType ulsexception12, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435e74, P4 microsoft.office.infopath.server, P5 12.0.6219.0, P6 4845c8d9, P7 9573, P8 194, P9 fileloadexception, P10 82lz.
To resolve this issue ensure that there are no empty parameter floating around in the ItemMetadata.xml files that the InfoPath form is not using. Once I removed all unwanted parameters the issue was resolved.