Delete Project through SQL

[Victor]

I have a project that needs to be deleted from Project Server. The
project does not show up if I open Project Professional so I can't
delete it from there. If I look in PWA Admin > Clean up Project Server
Database, I see it listed in there. However, if I try to delete it I
get the error "An error occurred while completing the operation" and it
won't get deleted.

I do not need to keep a copy of this project or anything about it. I
just want it gone since it shows up in some of my views and it should
not be there.

I looked in the MSP_PROJECTS table and I do not see a row for it.
However, I looked in the MSP_WEB_PROJECTS table and saw it listed in
there. Can I just delete that row from the MSP_WEB_PROJECTS table and
this project will just go away or are there other tables I need to
delete from?

Thanks,

Victor

 

[Ed Morrison]

Are you trying to delete the project with the SharePoint site? If so, try
deleting it with selecting the "Delete the SharePoint..." checkbox.

If you still error, backup your database first! Then take a look at the
MSP_WEB_SP_QRY_Delete... ForProjIDs queries.