Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-04-26 : 14:20:37
|
| Sorry I’m confused about the licensing:Is MSDE limited to 5 or 25 (or what) users/simultaneous connections?Am I correct in saying that MSDE has the OSQL utility instead of the GUI-based Enterprise Manager? But you can do practically everything with OSQL?I can get a Developer Edition of SQL Server for 49USD – does that include Enterprise Manager?Can I use that Enterprise Manager to develop solutions I can then ship as MSDE – i.e. royalty-free but with limited users?If I install one of those ubiquitous 120day evaluation editions, does my PC turn into a pumpkin after that, or does it leave any MSDE installations alone? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-26 : 16:01:06
|
| MSDE is limited to the number of simultaneous connections, with the word simultaneous being key. In most applications you connect-execute-disconnect rapidly so it takes quite a load to hit that limit. OSQL is a command-line interface to SQL Server that can be used by any version of SQL Server. EVERYTHING that can be done with a GUI can be done with a command. In fact, the GUIs just build the commands and run them.SQL Server Developer Edition is a full-fledged version of SQL Server, including client tools (Query Analyzer and Enterprise Manager). However its licensing is limited to development work. I cannot be used legally for a production server. You can develop all your solutions in it and ship them to run on whatever other SQL Server version you want.When the 120 day eval expires, the Microsoft Militia will storm your home, confiscating all computer technology, and use that cool pen from Men In Black to wipe your memory.Okay, I made that last one up. I don't know what happens when the eval runs out.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
MSDE/Dev Edition/Eval Copies - what can you do?