(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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
Printer-friendly version
Send to friend
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.
Sorry double entry
Thank you Zoltan
Thank you very much for your reply.
Does it mean to delete the table or to empty it.
Regards
Dieter
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
Email: PPadmin@planningplanet.com
Replies