September 3, 2010 at 9:52 am
Hi have a good day ,
I Buy SQL 2000 Personal Edition , and SQL 2000 Enterprise
then I use WinMerger ( Files Compare Software ) to compare
CD-ROMS of SQL 2000 Personal and Sql 2000 Enterprise
And I found that they have the Same (MSDE Files) ,
And After install (MSDE Only) for both editions I used SELECT @@VERSION
And they have the same version ???
so I downloaded the versions again from rapidshare , to make sure I am not scammed .
and I found the same result !!!
My Question :
Is MSDE that Microsoft says it's free , is the same MSDE included in
SQL 2000 Personal and Sql 2000 Enterprise ? , and On there web site ?
IF the Answer is yes ? ,
Then where is the limitations ? 2GB of database size , and 2 RAM GB
Thank you
September 3, 2010 at 11:03 am
MSDE is a scaled back version of SQL server that is Free. Do not confuse it with Enterprise Edition or Personal Edition.
If you are just installing MSDE - the edition makes no difference because there is only MSDE not MSDE Personal nor MSDE Enterprise.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2010 at 11:28 am
Thank you for your replay ,
Your answer explained everything to me ,
So I assume that After I Install the SQL 2000 Enterprise it will update MSDE that came with it , or may be it's has another MSDE embedded with it to install !
have a good day
September 3, 2010 at 11:33 am
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 5, 2010 at 12:38 am
Once you install MSDE, there is no upgrading it to another version like Standard, Enterprise, etc. You can install Enterprise as another instance of SQL on the same machine, but it will be totally separate, with its own set of databases, install files, services, etc.
Joie Andrew
"Since 1982"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply