Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  Need Help PRMDB-0495-2 Event Code

Author  Topic  Chaya Starting Member 1 Post Posted - 2011-10-04 : 13:06:16 Hi, I am currently using P6 Project mgt and everytime I need to delete some activity this event code keep on comming in: Type:EprmDBSQLExecutionFailure Event Code:PRMDB-0495-2 Description: PRM DBAccess Error: Database Server Error: The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes. can someone help me here. Thanks in Advance