08-29-2011 07:51 AM
I'm am using a ACT 2009 (11.1) Premium with a SQL Server. We've created a lot of costum fields in the contact - context. I've purchased the SA Password and saw that some fields are stored in the spillover table (ACT Whitepaper here). The Whitepaper itself says that these tables are used to "bypass" limits given by the sql server. Well, I've read some technet articles and was unable to find the limit which caused ACT to use the spillover table ... It seems that the "logic" is a little bit fuzzy. We've repeated the field creation and other (even more) fields where created in the spillover table.
This makes no sense to me ...
What are the limits the Whitepaper refers to?
08-29-2011 08:38 AM
08-29-2011 11:52 PM
08-30-2011 07:06 AM
thanks for the fast reply. I read these limits on technet articles. The funny thing is, wheter the bytelimit nor the max columncount is reached and on every try the result differs a little bit.
Thx for the reply so far. I've added the fields with the ACT-Client, not with the SA!