Description
Management studio permits for handling and connecting with the SQL Server from a graphical interface other then using the command prompt. And the application level alterations can be the most effective that has to be performed for altering the changes in the application level. And the process doesn't have much control over the third party applications and won't disturb the application that have been specified in the SQL Server database and that doesn't have much control over the internal applications.
Description
Below are the steps that the illustrate the procedural methods for Management Studios.
Step - 1
Open Microsoft SQL Server Management Studio.
Step - 2
Select the assigned server name and click on Connect button.
Step - 3
After click connect option it will open up the Object Explorer.
Step - 4
Expand Security from the object explorer.
Step - 5
It will display the list of valid user credentials.
Step - 6
Double click on the appropriate login credentials.
Step - 7
It will open up the Login Properties,then click OK button.
Key Points
- Management studio - Permits for handling and connecting with the SQL Server from a graphical interface other then using the command prompt.