P6 validate schema Missing Constraint task.fk_task_projwbs

Hi

From knowledge base i got the solution for oracle database,  please help me implement the same in SQL Server.

CREATE TABLE tmptask AS

SELECT task_id, proj_id, wbs_id

FROM task

WHERE wbs_id NOT IN (SELECT wbs_id FROM projwbs);

1. 4. Run the following statement to create a procedure (cleanup_orphans) which will be utilized to remove data from the TASK table

(and all child tables to TASK) which does not exist in the parent table (PROJWBS) using the values in the temporary table created from

step 3:

CREATE OR REPLACE

PROCEDURE cleanup_orphans

AS

VTASKID NUMBER;

VPROJID NUMBER;