how many data can storage into sql ce

Hi,

i want to know how many data can storage into sql server compact edition. I've got a db into a pocket pc that has a table with about 2000 records inside; are they too records?

YOu are not limited in rows, you can store up to 4GB (which should be pretty enough for PocketDevices :-) )

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de|||but i think that a sql server ce on a pocket pc has some limitation, or not?|||

Please see this topic in SQL CE Books Online - http://msdn2.microsoft.com/en-us/library/ms172451.aspx

"The following table specifies the maximum size limitations for several database objects defined in Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) databases. "

|||ok