![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: History Function Topic Summary: Reporting History and Cleaning Up History Created On: 4-Aug-2006 16:32 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I am considering implmenting the use of the History Function on our project and I was wondering if anyone knew the answers to the following questions
1) If i wanted to generate a Report based upon the information held in the History what would I query? 2) After numerous changes to a Diagram or Definition if the History Table grows to large and I want to truncate some of it, how do I go about doing it in SA? Thanks! |
|
![]() |
|
![]() |
|
I've yet to get 10.4 and the history function but I would recommend the following:
To reduce the size of the database, choose the database via the Encyclopedia manager and use the Shrink function form the menu, Database :: Shrink. Or you can shrink the database via a SQL string. This what I would do if I was flying blind (which I am ![]() dbcc shrinkfile(your_database_name,'truncateonly') dbcc shrinkfile(your_database_name_only) The first shrinkfile truncates your log files and the next one shrinks the database. Ensure you have adequate backup obviously. To find the table to query for reports, I'd run the following SQL string: SELECT * FROM INFORMATION_SCHEMA.TABLES Hope this helps. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.