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