We have projects that have been published, so they have a value in the 'Last Published' field in both the Draft and Published DBs.
Sometimes we delete projects from the Published database only and the 'Last Published' field remains populated.
But, I need to determine if the project is in the Published database by querying SQL. What's the best option? Simply comparing projects in the Published vs. Draft database doesnt work...even after deleting from the Published store, the project
is still referenced in the Published DB?
So, what is the best option for identifying whether or not a project is in the published database using SQL?
If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82