Previous Thread

8/18/2006 3:23:12 AM    Max number of entity attributes
Hi , 
 
Does any one know what is the maximum number of attributes I can 
 
add for a system or custom entity. 
 
thanks, 
 
Hassan.



8/18/2006 8:29:10 AM    Re: Max number of entity attributes
I would have thought this also depended on the number of columns 
 
allowed in a sql table, and the number of columns already used by the 
 
entity? 
 
Mark wrote:

8/18/2006 11:50:55 AM    Re: Max number of entity attributes
The custom attributes are stored in a separate SQL table, so you can 
 
use up to 8060 bytes for adding  your custom attributes. 
 
Number of Bytes Required per Attribute 
 
Boolean 1 
 
Datetime 8 
 
Picklist 4 
 
Integer 4 
 
Float 8 
 
Money 8 
 
ntext 16 
 
nvarchar (n) n x 2 
 
Mark 
 
On 18 Aug 2006 03:23:12 -0700, "hassanhussain@gmail.com" 
 
<hassanhussain@gmail.com> wrote:

8/18/2006 6:35:47 PM    Re: Max number of entity attributes
Look at the SQL Server documentation (help). It's listed in the topic 
 
"Maximum Capacity Specifications". For Sql Server 2005 it's 1024 columns per 
 
table. I don't have a Sql Server 2000 available right now, but the docs 
 
should contain the same information. 
 
-- 
 
Michael 
 
http://www.stunnware.com/crm2 
 
---------------------------------------------------------- 
 
<googposter@hotmail.com> schrieb im Newsbeitrag 
 
news:1155914949.976040.147220@b28g2000cwb.googlegroups.com...