ms-sql server "light"

I have read that there is a free version of Ms-Sql Server for educational
purposes. Is it true? thank you.Microsoft does have discounted licensing programmes available for
educational institutions but, as far as I'm aware, there isn't a special
"educational version".
http://www.microsoft.com/education/?ID=HowToBuy

MSDE is a free distributable version of SQLServer with certain limitations
and without the client tools:
http://www.microsoft.com/sql/msde/

There is also a 120 day evaluation available as a free download:
http://www.microsoft.com/sql/evalua...ial/default.asp

--
David Portas
----
Please reply only to the newsgroup
--

"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.|||Should have mentioned that there is also a Developer Edition priced at
$49.95. However, there are licensing restrictions on the use of this. You
would need to verify that your intended use comes within the terms of the
licence.

http://www.microsoft.com/sql/howtobuy/development.asp

--
David Portas
----
Please reply only to the newsgroup
--

"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.|||"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.

You're probably thinking of MSDE:

http://www.microsoft.com/sql/msde/d...ds/download.asp

Simon|||Ok it could be the MSDE2000. But with it what can I do? is like
MsSqlServer(ide,...) or is only an engine?

"Simon Hayes" <sql@.hayes.ch> ha scritto nel messaggio
news:3fc89409_1@.news.bluewin.ch...
> "billo" <jalden@.NOSPAM.it> wrote in message
> news:dK%xb.121072$hV.4371271@.news2.tin.it...
> > I have read that there is a free version of Ms-Sql Server for
educational
> > purposes. Is it true? thank you.
> You're probably thinking of MSDE:
> http://www.microsoft.com/sql/msde/d...ds/download.asp
> Simon|||"billo" <jalden@.NOSPAM.it> wrote in message news:<jZ8yb.123661$hV.4486085@.news2.tin.it>...
> Ok it could be the MSDE2000. But with it what can I do? is like
> MsSqlServer(ide,...) or is only an engine?
> "Simon Hayes" <sql@.hayes.ch> ha scritto nel messaggio
> news:3fc89409_1@.news.bluewin.ch...
> > "billo" <jalden@.NOSPAM.it> wrote in message
> > news:dK%xb.121072$hV.4371271@.news2.tin.it...
> > > I have read that there is a free version of Ms-Sql Server for
> educational
> > > purposes. Is it true? thank you.
> > > > You're probably thinking of MSDE:
> > http://www.microsoft.com/sql/msde/d...ds/download.asp
> > Simon

You can see the details of what's in MSDE on the MS web site. The main
points are that databases are limited to 2GB, performance drops with 5
or more concurrent connections, and there are no client tools except
for command line ones such as osql.exe (no Query Analyzer, Enterprise
Manager, Profiler etc.).

If those limitations aren't acceptable, then you could look at the
development edition, which I believe is the same as Enterprise
Edition, but only licensed for development.

Simon|||It's "only" the engine. If your purpose is to teach people the SQL Server
tools/IDE stuff then you'll need to check with MS what the best licensing
scheme for you is for the full SQL Server product.

> Ok it could be the MSDE2000. But with it what can I do? is like
> MsSqlServer(ide,...) or is only an engine?

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...epartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq