For a C# programming assignment I have to create a table in Microsoft SQL Server. I have Visual Studio 2013 and Microsoft SQL Server 2012 freshly installed. As I installed it I specified my user for admin access (this is on a laptop with only my user anyway). I can't seem to be able to fully follow my teacher's instructions for the assignment:
Right click on Data Connections > Create New SQL Server Database The Create New SQL Server Database window opens
Select a Server name (default: .\SQLEXPRESS
)
College
as the new database nameClick OK
In Server Explorer you’ll find a new Database listed under Data Connections
College
database)On number 4, the only server that appeared was "MORTHOS" which is my computer name. (I am hoping that this is arbitrary). I was able to create a new DB named college. When I get to 6 I find that my progress grinds to a complete halt. I only have the options Refresh and properties and can't see where to add a new table as pictured here:
I know it has a valid connection, because it was able to successfully create the College database. I can even confirm that it has a good connection when I click "test":
Can someone please tell me what I am doing wrong?
EDIT: in SQL Server Management Studio I do see myself under the logins:
In SSMS, in Object Explorer, connect to the instance of Database Engine that contains the database to be modified. In Object Explorer, expand the Databases node and then expand the database that will contain the new table. In Object Explorer, right-click the Tables node of your database and then click New Table.
To design a new table, open SSMS and connect to your sql server instance. In Object Explorer, expand the HR database or the database where you want to create a new table. Now, right-click on the Tables folder and select New Table , as shown below.
As soon as you start SQL Server Management Studio (SSMS) the Object Explorer should open. If not then you can open it by one of the following ways: Pressing the shortcut key F8. From the menus select View > Object Explorer as shown below.
If you only see Refresh and Properties when you right click on Tables in Server Explorer, you probably need to install SQL Server Data Tools from http://msdn.microsoft.com/en-us/data/hh297027 .
Use update
after you create the table, don't use save
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With