Microsoft BI-Azure and Project Server Blogs

a very good article to understand SSP in MOSS 2007 MOSS SSP Walk through on Configuring SSP in MOSS 2007

SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%WVIEW_TIMESTAMP%' ORDER BY schema_name, table_name;

The latest Cumulative Updates (CU) for Project and Project Server 2010 and 2007 have been released. There was a problem found in both the 2007 and 2010 Server Rollup Packages which required a fix and for the patches to be rebuilt Project and Project Server 2007 This include a number of fixes, so Microsoft strongly recommends that you test this in a test environment based on your production environment before putting this fix live in production. The article below provides information on how to deploy the Project Server Cumulative Update. Deploy cumulative updates (Project Server 2007) http://technet.microsoft.com/en-us/library/dd239177.aspx Service Pack 2 for both WSS and Office Servers 2007 are required for this Cumulative Update. The KB articles below provide information on how to download and install SP2 if you have not already done so. o Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2 o http://support....

below is useful link for Number formatting http://msdn.microsoft.com/en-us/library/0c899ak8.aspx

Project Server 2007 Blogs: Application event handeling setting Project level Enterprise custom field

Private Sub App_ProjectBeforeSave(ByVal pj As Project, ByVal SaveAsUi As Boolean, Cancel As Boolean) If pj.CurrentView = "Publish Project View" Then 'pj.Tasks.Item(1).Name = "Test View level " 'pj.ProjectStart = Now() 'pj.StatusDate = Now() 'MsgBox ("Inside view published") 'Else Dim x As String 'x = "XYZ" x = ActiveProject.ProjectSummaryTask.GetField(FieldNameToFieldConstant("- Groups", pjTask)) If x = "" Then 'confirm = MsgBox("Please go to Menu-->Project-->Project Information-->select your 'Group'", vbYesNo) confirm = MsgBox("You did not select Group,do you want to select it", vbYesNo) If confirm = 6 Then Cancel = True MsgBox ("Please go to Menu-->Project-->Project Information-->select your ' Group'") Call ActiveProject.ProjectSummaryTask.SetField(FieldNameToFieldConstant(" - Groups", p...

Application Events> using application events requires a few steps. The first step is to create a new class module and declare an object of type Application with events. Creating the class module is done by going to the insert menu and selecting "ClassModule" When you have done this, double click on the class module and declare the object by using the following code: Public WithEvents App As Application After the new object has been declared with events, it appears in the Object drop-down list box in the class module, and you can write event procedures for the new object. (When you select the new object in the Object box, the valid events for that object are listed in the Procedure drop-down list box.) Writing the procedure is similar to writing any macro. The image below shows a simple example using the ProjectBeforeTaskChange event. Note that NewVal holds the value that the user has input. The original value can still be referenced in the standard way (t.Name). The code t...