Posts

Showing posts from August, 2017

Working with Microsoft SQL Server

Image
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.

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 choose SQL Server authentication), and selecting the database to use as a default.
Step 4 :   Click the Ser…