Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 About licensing
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

12 Posts

Posted - 05/14/2005 :  03:08:36  Show Profile
I have developed a application for 2 companies which use MSDE in the backend. The clients request for an installation package recently, can I include MSDE2000 or later SQL Express in my setup package?

Pointy Haired Yak DBA

4184 Posts

Posted - 05/14/2005 :  13:55:25  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message
If you're asking strictly from a licensing perspective, then the issue would be yes. Also, what do you mean by MSDE2000 as opposed to MSDE? What version of MSDE are you using now?


When life gives you a lemon, fire the DBA.
Go to Top of Page

Starting Member

12 Posts

Posted - 05/17/2005 :  23:55:16  Show Profile
Does the version of MSDE affect the license? I only want to refer to the MSDE having the same engine with SQL Server 2000.
Is there any registration I need to make as I am going to distribute database engine.
Go to Top of Page

Flowing Fount of Yak Knowledge

3575 Posts

Posted - 05/18/2005 :  00:07:32  Show Profile
you can bundle MSDE with your app without worrying about any licensing issues. keep in mind that MSDE has some limitations:

1. Limited to 2GB database size
2. Limited to 2GB RAM
3. Workload governor
4. lacking most SQL client tools (no EM, QA, books online, profiler etc.)

there are more limitations, but these are the major ones that I can think of.

There are 3 versions of MSDE so far, MSDE 1.0 (which was based upon SQL 7.0), MSDE 2000 (which is based on the SQL 2000 codebase) and SQL Express (based on SQL 2005).

SQL Express is a little more limited than MSDE 2000 in some ways, and more capabable in other ways. Microsoft switched things up a bit just to keep us on our toes.

1. Limited to 1 CPU
2. Limited to 1 GB buffer cache
3. 4GB database size
4. no workload governor
5. No SQL server agent (no scheduler)
6. GUI management tools are now included (Express Manager)

Again, there are more differences and limitations, but these are the ones that come to mind.


Edited by - eyechart on 05/18/2005 00:12:16
Go to Top of Page

Starting Member

12 Posts

Posted - 05/18/2005 :  00:31:05  Show Profile
Thanks a lot! I got much less worry about the license now.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000