Is there a copy of, or a spreadsheet that lists what values are pre-populated in T_KEYWORD, T_KWCODED_VALUES, TR_QUERY_ELEMENT, and TR_QUERY_ELEMENT_PARAMETERS? I'm no longer sure what records are original, which have been added and which have been modified.
Thanks
Hi Levi
You probably should get yourself a fresh copy of the installation database to play with . It should contain the original data for those reference tables for comparison.
We did that when we were doing a whole lot of testing in the context of moving the databases to a new server - Might be useful in Your Situation to have a reference copy to hand for other scenarios as well?
Ken McSwain Business solutions Manager
kmcswain@sydneyoperahouse.com
T+61 2 9250 7876 F+61 2 9251 7821 M 0418 659 360
SYDNEY OPERA HOUSE BENNELONG POINT
GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA
SYDNEYOPERAHOUSE.COM
Please consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====