L
ljsexton
How do I find the DB Schema to help locate orphaned records in DB? Since we
executed the MPA SLQ for removal of Deleted Tasks from the PWA Tasksheets one
of our resources has consistently been getting a notification everyday.
Research shows that this resource was removed from that project almost a year
ago. I even deleted the project from the project server database and she
still continues to get these messages. Feel certain there is an orphaned
record somewhere but not sure how to go about locating it - do not know what
the DB schema is so unsure what tables to look in ...message is "The
following tasks are overdue and incomplete". Any suggestions would be greatly
appreciated. My real concern is how many more orphaned records are there that
I do not know about - need some kind of utility to "Clean up" data on a
periodic basis -
executed the MPA SLQ for removal of Deleted Tasks from the PWA Tasksheets one
of our resources has consistently been getting a notification everyday.
Research shows that this resource was removed from that project almost a year
ago. I even deleted the project from the project server database and she
still continues to get these messages. Feel certain there is an orphaned
record somewhere but not sure how to go about locating it - do not know what
the DB schema is so unsure what tables to look in ...message is "The
following tasks are overdue and incomplete". Any suggestions would be greatly
appreciated. My real concern is how many more orphaned records are there that
I do not know about - need some kind of utility to "Clean up" data on a
periodic basis -