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: [email protected]
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"