Skip to content

POBS, can I delete all records?

Dieter WambachMember for 19 years 9 months
Created
4
2
0

Hi to all

over the years the POBS table became huge and every record is included in XER.

To improve at the roots: Is it possible to delete all records from that table maybe apart from on record?

Kind regards from Berlin, Germany and thank you for your support

Dieter

4 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    yes you can delete the POBS

    yes you can delete the POBS table you need to delete it from your database as well as celaning ALL xer's before importing them if you do not remove them from your database then every time that you give soemone an xer it will have a POBS table in it 

    to clean the POBS table from your database do this 

    you will have to use microsoft sql and execute this scrpit

    delete from POBS;

    to clean any pobs table download this free program and run it ion all xers prior to importing them 

    http://scheduleanalyzer.com/PurgePOBS.exe

  2. 0
    Dieter Wambach ·

    Thank you ZoltanThank you

    Thank you Zoltan

    Thank you very much for your reply.

    Does it mean to delete the table or to empty it.

    Regards

    Dieter

  3. 0
    Dieter Wambach ·

    Sorry double entry

    Sorry double entry

  4. 0
    Zoltan Palffy ·

    you want to delete it How to

    you want to delete it

     How to Purge a database of POBS tables

    1. Go to start programs Microsoft SQL Servere 2005, SLQ Server Mnagement Express Studio

    2. Connet to Sql Server

    login is SA

    password is Prima123Vera

    3. Highlight and expand the database locally the default is PMDB

    4. Select New Query

    5. When the New Query is present type this into the query

    delete from pobs;

    6. Next right click and select Execute

    7. After the script executes a message window will appear at the bottm and tell you how many rows  it has cleaned. 

    8. Click the upper right to exit the database. A message will appear asking to Save changes to the following items ? Select NO.

    Now the database has been cleaned. Use the link to get the xer purge utility to purge the POBS table from ALL xer files prior to impoting them into the database.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?