How do I create a SQL Server Express database with SSMS?
I want to create a SQL Server 2008 Express database. I've found articles describing how to do this with Visual Studio, which I could do, but I'm wondering if it is possible to create a SQL Server 2008 Express database using SSMS? I've got SQL Server 2008 R2 Developer Edition installed on my development box.
Certainly, as long as you have SQL Server Express installed. You can connect to it via SSMS just like R2 Developer Edition and then create a new database using either the T-SQL Create Database command or the gui by right clicking on Databases in Object Explorer and choosing New Database. SQL Server Express is available as a download from Microsoft and can be installed side by side with developer edition if you need to. I believe it may also be installed by default along wtih Visual Studio, but I could be wrong on that one.