Trigger on MSP_Text_Fields table not working (SQL Server 2000)

Microsoft Project


  • 1. Hiding macro code
    Apologies if this sounds stupid but I am the Web/DB guy. A colleague has developed a macro the creates a tabbed report. He would like to "hide" to VBA code somehow. What is the best way t o do this? Can he build a VB DLL and call out to it somehow? Thanks
  • 2. Creation of enterprise resources
    Hello, We are trying to create enterprise resources via SQL. These should contain the complete cost information (therefore we cannot use PDS b/c it does not allow to set all the cost fields). Unfortunately, the resource fields are stored as binary data. Does anybody know the format? Is there a documentation for this format? Is there any other way to have the binary data created? Thanks much
  • 3. freezing first few fiels in the Gantt view while working on others
    Hello Dear: Would you please advice whether we can freeze first few fields in the Gantt view while we are working on the other fields similar to excell spread sheet? It is very convinient to do freeze the columns because we do not have to go back and forth while updating the same row Please advise Thank you Majid
  • 4. Creating a "consolidated views" page without using WSS
    Hello. Our config: Win2000 Server, Project Server 2003, SQLServer 2000 on one machine Trying to evaluate Project Server 03 for our organization (I am not a programmer). Our objective is to create a custom PWA "consolidated" view that shows the "stoplight" chart with custom cost fields along with resource allocation table view or more simply, demonstrating the dashboard concept. I've combed through most of the documentation and it usually alludes to using WSS to create custom web pages with OWC's. My question is, how do I go about customizing PWA using OWCs without WSS? Is there a "how-to" reference someone can point me to? I know in concept, you can create an ASP page with objects that you could like as a custom menu. But other than that, I'm flying in the dark. Thanks in advance for any assistance.
  • 5. filter few customized columns by date or date range AT ONCE
    I have 5 customized date columns per each project ( in one row) and I have about 200 projects. each column has deliverable date inserted. So, for each project I should have 5 deliverable dates at different time interval. How can I filter all 5 columns at once for a particular date or date range? right now i can filter one column at the time Perhaps I should write VBA code that is able to filter all projects by the date or range of the interest? Please advise Thank you for your help

Re: Trigger on MSP_Text_Fields table not working (SQL Server 2000)

Postby Rod Gill » Mon, 15 Jan 2007 15:38:12 GMT

Reading the pjdb.htm file (in one pf Project's program folders) there is the 

Placing triggers on Project database tables may cause data corruption or 
return unexpected results. It is important to note the following:

  a.. Any procedure fired by an INSERT or UPDATE trigger does not alter the 
@@identity property.
  b.. A procedure fired by an INSERT or UPDATE trigger must not perform an 
INSERT into a table with an Identity column or otherwise cause an Identity 
value to be generated by Microsoft SQL Server 2000.


Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit:  http://www.**--****.com/ 

Similar Threads:

1.Incorrect Data from ODBC/Sql Server 2000 table.

I have been trying to "Open" an ODBC data source which is a Sql Server 2000 
table. The datetime columns contain around-the-clock values, and the 
RunDuration column contains minutes (have tried float and integer types.) I 
set the timescale to Minutes/10.
Create table JobHistory (Name     Varchar(64),     (Name)
                         RunDuration      float,                (Duration)   
                         RunDateTime     DateTime,        (Start)
                         EndDateTime      DateTime)       (Finish)

Gant Chart shows "Point" length tasks.  The DateTime columns are always 
interpreted by Project as AM time, never PM.  Also, RunDuration is in 
minutes, and it appears to be sometimes ignored or the decimal place is 
slipped one to the left (ex. 29.0 becomes 2.9).  I have tried different 
permutations of column-to-Project mappings but nothing changes for the 

Am I wasting my time with Project?  Is this another feature that simply does 
not work or are there some obscure settings which allow MS Project to work 
with MS Sql Server?  I want to make this work but sheesh!  This should be 

Best regards

2.Project Server working with SQL Server 2000 SP 4

Has anyone been able to get Project Server 2003 to work with SQL Server that 
has SQL SP 4 applied to it?

Thanks in advance,


3.Can we integrate Project server 2003 on SQL 2000 with WSS on SQL 2

Can we integrate Project server 2003 on SQL 2000 with WSS on SQL 2005.
WSS is on SQL 2005 and we plan to install Project Server in a seprate box on 
SQL 2000 . Does it give any problems? - Upgrading project Server 2003 DB from SQL 2000 to Sql 2005 -

Hi All,

We are also planning to upgrade our DBs for Project Server (ProjectSErver) 
and WSS (WSSContent) from SQL 2000 and SQL 2005. Any recommendations or best 
approach to perform this upgrade?

thanks in advance.

best rgds,


"John Foster" wrote:

> You may want to look into some pitfalls related to the versioning of the database on 2k5. I have read that there are some compatibility problems in this scenario.
> They can be mitigated by setting the compatibility of the database on SQL2k5 to SQL2k.

5.MIgrate Sql Server 2000 database to sql 2005


I am using MOSS 2007 and PS 2007. I want copy all the existing databases to 
New server with sql 2005 database. Is there any documentation available on 
this which tells me step-by-step instruction.

If I copy only PS2007 (Sql 2000) databse to new server with sql 2005 db, 
will this is possible?


6. Upgrading project 2007 server from sql 2000 to sql 2005

7. Can Office Project 2003 Server be migrated from SQL 2000 to SQL 20

8. Moving MOPS/WSS databases from SQL 2000 to SQL 2008 server

Return to Microsoft Project


Who is online

Users browsing this forum: No registered users and 15 guest