>>> Does it mean that if server machine is powerfull and batches are executed very very quickly the limit mesured in users is much more that 5 ?
>In other words - does it mean that limit mesured in concurrent working users depends on power of computer running MSDE ?
>
>I suppose you could infer this on the assumption that a more powerful server could get the query processed faster making it less likely that two or more batches would be processed simultaneously.
>
>In reality, the queries (batches) are likely to come randomly so the more users that you're trying to support the more likely it is that you will hit the five batch "limit." The good news is that you can use DBCC CONCURRENCYVIOLATION to monitor and measure the number of times that you are hitting the five batch "limit" and if it is occuring often enough, upgrade to the full server product.
>
>-Mike

Hi Mike !
Yes I took the assumption that the shorter the time of batch processing the lower probability of collision. Thanks for the answer and thanks also for participating in writing great book.