Working with Microsoft SQL Server
What is SQL Server Management Studio? SQL Server Management Studio (SSMS) is the main administration console for SQL Server. SSMS enables you to create database objects (such as databases, tables, stored procedures, views etc), view the data within your database, configure user accounts, perform backups, replication, transfer data between databases, and more. Fig 3 : SSMS Console Window User Login : When creating a new user login, the administrator can assign that login to any number of roles and schemas. This will depend on what that particular login is entitled to. Create a New Login Step 1 : Using SQL Server Management Studio, expand the Security option (at the server level, not at the database level) and right click n Logins. Step 2 : Click on New Login. Step 3 : Complete the login properties in the General tab by providing a name for the login , choosing the Authentication method (providing a password if you choos