SQL Server Express Guide
I got a bit of time this weekend to play with SQL Server Express (SQE) and here are some more details on it. I installed this part of Whidbey 2005. By default the setup installs this under the SQLEXPRESS instance name, so to connect to it you would use something like “machinename\SQLEXPRESS”. The API set for SQL Server Express is the same as SQL Server so upgrading from one to the other would not be a problem. A new GUI tool called SQL Server Express Manager (XM) will be freely available as a separate Web download. XM will allow easy database management and query analysis capabilities, will have a small download size, and will be freely redistributable. XM is a lightweight tool built on top of the latest version of the .NET Framework and the new SQL Server System Management Objects API. ...