It is suggested to manage SQLEXPRESS using SQL Server Management Studio Express, which is free from Microsoft.

1. Download SQL Server Management Studio Express. Go to:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

 2. After install it successfully, open the studio and log on your EQLEXPRESS server. Note that the server name must include EQLEXPRESS following your machine name and Windows Authentication should be used.

connectsql.jpg

3. The Object Explorer is displayed after a successful login.

tablesql.jpg

4. To create a database, right-click the Databases folder and select the New Database menu item.

5. To create a table, right-click the Tables folder and select the New Table menu item. 

Leave a Reply