Brian's Blog

items I see across my tribes

SQL Server Express Edition

April 08
by briancarter 8. April 2009 06:59

What are the limitations of SQL Server Express? 

I've been asked this question a few times, in different context.  It is interesting since it is after all free.  So SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine.

While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory and 4 GB database files. The entire database is stored in a single .mdf file, and thus making it suitable for XCOPY deployment. It is intended as a replacement for MSDE. Two additional SQL Server 2008 versions provide a superset of features not in the original Express Edition. The first is SQL Server Express with Tools, which includes SQL Server Management Studio.  It is a free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008.  SQL Server Express with Advanced Services adds full-text search capability and reporting services.

Get more information at the Wiki and at Microsoft.

Categories: Development

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




 Questions or Feedback, my contact information is located on my About page.


The opinions, thoughts, and comments made in these blog posts are solely my own (unless otherwise stated). They do not reflect the opinions, thoughts or practices of my employer, my universities, my family, or anyone else. Also, I retain the right to change my mind about anything I publish here without having to go back and edit posts that occurred in the past. 

These are my opinions, or just as likely, someone else's opinions that I leveraged for my own.