what's the difference bet. SQL Server Express and SQL Server Standard??

Good day... I need your help guys... can somebody please state what's the difference bet. SQL Server Express and SQL Server Standard??  what are the features of both SQL? 

please pardon me about this, because i'm new in this field... 

Thank you guys...  Have a merry christmas and a happy new year... ^_^ 

Hi Raphael,

You can get a breakdown about the featureset of each SQL 2005 release here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Basically, SQL Server Express is file based and much similar to how you use MS Access. SQL 2005 on the other hand is an entry level database server that has the minimum toolset and capability compared to the Enterprise version. Think of it as a watered down version of SQL enterprise.

 HTH

Just to clarify, SQL Server 2005 Express is more than just a file-based database.  It runs as a service unlike MS Access. Think of it as the 2005 version of MSDE

bass_player:

Just to clarify, SQL Server 2005 Express is more than just a file-based database.  It runs as a service unlike MS Access. Think of it as the 2005 version of MSDE

True and I agree it runs as a service but if you think of it it's much closer to how you use Access(if it's ASP.NET) than how you use MSDE.