SQL: Delete project-level custom fields

K

Kris R.

***Project Server 2000***
I'm trying to delete 2 enterprise project-level custom fields (one date, one
number). The SQL I'm using is this:

--delete ProjectEnterpriseDate1 (Deadline) from date fields table
DELETE FROM ProjectServer.dbo.MSP_Date_Fields where Proj_ID = @Proj_ID AND
Date_Field_ID = 188744539
--delete ProjectEnterpriseNumber1 (Warning) from number fields table
DELETE FROM ProjectServer.dbo.MSP_Number_Fields where Proj_ID = @Proj_ID AND
Num_Field_ID = 188744690
--delete both from view table
Update ProjectServer.dbo.MSP_View_Proj_Projects_Ent set
ProjectEnterpriseDate1 = null, ProjectEnterpriseNumber1 = null
WHERE Ent_ProjectUniqueID = @Proj_ID
--flip externally edited bits
Update ProjectServer.dbo.MSP_Projects SET Proj_Ext_Edited_Date = 1,
Proj_Ext_Edited_Num = 1, Proj_Ext_Edited = 1
WHERE Proj_ID = @Proj_ID

After executing this, the values are indeed gone from the specified tables.
BUT, when I open the project in Pro, and open the "Project Information"
window, these values are still present. I tried forcing calculations, but
the values are still there.

What am I missing in the delete?

Thanks,
Kris R.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top