question

Rod avatar image
Rod asked

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.
sql-server-express
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
TimothyAWiseman avatar image
TimothyAWiseman answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.