Let us first login to SQL azure database.
Once we login we will see this work area
Let us create our testable
To login to SQL Azure from Management Studio we will be using the same login we used before and the authentication type will be SQL Server
Now we will have our database connection to our cloud database and access to the table we created previously.
But if we simply try to work with the table without creating a clustered index SQL Azure will return error.
Let us now create a clustered index on the ID column and try to execute the about statement again.
This time we are able to add record to or table. Net let’s go back to SQL Azure and see we did really added one row.
We manage to add a row to SQL Azure from SQL Server Management Studio indeed.