What is SQL SERVER Express 2005 Edition? | SQL Server Interview Questions

SQL SERVER Express edition is a scaled down version of SQL SERVER 2005 and next evolution of MSDE.
Below listed are some major differences between them:-
=> MSDE maximum database size is 2GB while SQL SERVER Express has around 4GB.
=> In terms of programming language support MSDE has only TSQL, but SQL SERVER Express has TSQL and .NET. In SQL SERVER Express 2005 you can write your stored procedures using .NET.
=> SQL SERVER Express does not have connection limitation which MSDE had and was controlled through the work load governor.
=> There was no XCOPY support for MSDE, SQL SERVER Express has it.
=> DTS is not present in SQL SERVER express while MSDE has it.
=> SQL SERVER Express has reporting services while MSDE does not.
=> SQL SERVER Express has native XML support and MSDE does not.
Note: Native XML support mean now in SQL SERVER 2005  :-
=> You can create a field with data type "XML".
=>      You can provide SCHEMA to the SQL SERVER fields with "XML" data type.
=> You can use new XML manipulation techniques like "XQUERY" also called as "XML QUERY".
There is complete chapter on SQL SERVER XML Support so till then this will suffice.