Thanks Rick for clearing that out. I didn't really paid attention to the data on the table and I was just looking at the number of rows. My mistake. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, April 14, 2008 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: Difference between H and T table on SQL 2005 ** The H tables store Status History. As such, they've been around for a VERY long time. Not all forms contain an H table, but all Regular forms do - basically any form that contains the core field Status (Field ID 7).
Rick On Mon, Apr 14, 2008 at 10:37 AM, tricky maybe <[EMAIL PROTECTED]> wrote: ** I'm just curious what the difference is between the T table and the H table on SQL 2005. I don't think the H table existed before we upgraded from SQL 2000. They sure look the same for me but I'm not a SQL guy so I'm not sure why there's an H table now. They both look the same with the same number of rows like if I open table T111 it brings up 50 rows and if I bring up table H111 it brings up the same records. We will have this table push to another SQL server but I'm not sure which table to push. It is the H or the T table and why? Please advise. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"