MSDE and SQL SERVER

[vias]

What are the main differences between MSDE and
SQL Server?

I would like to know how many concurrent users
can the MSDE engine support on the web?

Thanks

 

[nigelrivett]

MSDE is like the standard edition without the client applications.
It will support any number of users but is governed to slow down at more than 5 concurrent workloads. In a web environment where you would normally call a very short SP then disconnect it can cope with many users.

see

http://www.nigelrivett.net/VB6DataAccessLayer.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nigelrivett]

Sorry wrong link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[vias]

Thanks for your info.