Script to delete a project from project server SQL tables

I

I-Ali

Hi All:

I am looking for a SQL script that you may have used to delete project and
associated data from PS 2002 SP1 SQL database. I have certain corrupt
projects that are stored in PS SQL database. These corrupt projects have
PROJ_CHECKEDOUT set to 1 in MSP_PROJECTS. These projects do not show up in
the list of checked out projects in PWA (Admin -> Manage enterprise features
-> Check in projects). I also found out that these projects have a
PROJ_DATA_SOURCE set to NULL and not to PC10DSN as for a regular project.
That probably explains how these projects got in to teh SQL tables. Also,
these corrupt projects are not listed in Proj Pro client or PWA.

I want to remove these projects and associated assignment data and resource
data from related tables. I would appreciate it if you can provide me with
the SQL script that deletes these corrupt project and associated data from
SQL tables. The database layout is one corresponding to Project Server 2002
SP1.

Thanks,
I-Ali
 

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

Similar Threads

Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Sync between PWA-view data and data in the project data base 1
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
CONVERT MS PROJECT 2007 DATA INTO MS SQL SERVER 1
Where is the baseline last saved date stored in Project Server 2003? 2
Opening a Project in SQL Server Using VBA 8
Extracting Project and Resource data (flat) file using SQL Mgmt St 3
Project Server 2007 and SSRS 2005 integration: issue withauthentication when running to the reports 3

Top