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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 shareware for SQL Server 2000

Author  Topic 

Ileana
Starting Member

3 Posts

Posted - 2007-07-31 : 10:31:41
Does a shareware / lite / express edition for SQL Server 2000 exist?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-31 : 10:33:02
For SQL Server 2000 there is MSDE
For SQL Server 2005 there is SQL Express




E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Ileana
Starting Member

3 Posts

Posted - 2007-07-31 : 10:45:56
Thank you. Your help is appreciated.
Go to Top of Page

Ileana
Starting Member

3 Posts

Posted - 2007-07-31 : 12:30:46
Any known installation issues with MSDE?
(SQL Server Express for 2005 is not an option yet for our customer; we need to stay with 2000).
Thank you.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-07-31 : 13:52:08
"Any known installation issues with MSDE?"

Database size limit of 2GB. "Throttles" if more than 5(??) concurrent queries running. Other than that it behaves pretty much the same as its Big Brother version.

Kristen
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-31 : 23:05:53
Can only use 1gb memory and single cpu.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-01 : 00:50:11
you should tell us about what you intend to use it for and then we might be able to determine if you will run into issues.

keep in mind you get what you pay for. A free database like MSDE is not going to have all the bells and whistles that the full blown SQL Server offerings have.

oh, and google things a bit. googling 'msde limitations' turns up this link http://databases.aspfaq.com/database/what-are-the-limitations-of-msde.html that should pretty well answer all your questions about MSDE.





-ec
Go to Top of Page
   

- Advertisement -