>Hi,
>
>I want to use MSDE for smaller clients (< =5 user network).
>The know the limit of MSDE (2 GB), but what is base of that limit:
>
>1. data (only data from tables) or
>2. data (data from tables, index, triggers, stored procedures ...) or
>2. data file and transaction file added
As I understand it, it's the maximum size of a single database (.MDF file) which contains everything in #2 above. The transaction log file is separate. I don't know how large an MSDE transaction log may grow.
If necessary, you can use more than 1 database simultaneously in MSDE.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up