Reading the pjdb.htm file (in one pf Project's program folders) there is the following: 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/
Trigger on MSP_Text_Fields table not working (SQL Server 2000)
1 posts
• Page 1 of 1
- 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
Next
Re: Trigger on MSP_Text_Fields table not working (SQL Server 2000)
by Rod Gill » Mon, 15 Jan 2007 15:38:12 GMT
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
better.
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
easy!
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, JD
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?
4.re - 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, Noynoy "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
Hello 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? Ashish
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
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 15 guest