Deleting a project via SQL?

D

DJ

The situation:

Within PWA, under the 'clean up database' section a
project is listed.
This identical project is listed within the 'Open Project'
box within MSProjects as well. Makes sense right.

The project is also listed within the MSP_PROJECTS table.

This is fine and dandy but I am unable to delete the
project schedule in question!

I have tried deleting the project via PWA. Unsuccessful.
I have tried deleting the project via ODBC connection.
Unsuccessful.

I am short of attempting to delete the project via SQL but
am not sure I should go that route.

Any ideas of what could be happening and how I can get rid
of this project?

Are there any special circumstances I should be aware of
when using SQL to delete a schedule?
 
G

Gary Chefetz [MVP]

DJ:

Is this project showing as checked out? If so, check it in. If not, verify
that the proj_checkedout field in MSP_PROJECTS is set to a value of 0
(zero).

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
D

DJ

No the project is not checked out -- I have attempted to
reset all the values on the table. No luck -- I have
reset all the relevent fields in MSP_Projects to zero with
no avail....
 
Top