[go: up one dir, main page]
Scribd
Upload
21 views2 pages

Introduction To SQL Server Management Studio

SQL Server Management Studio is the primary tool for SQL Server administrators and users to manage and develop databases. To access it, users can navigate through the START menu and connect to the server using either Windows or SQL Server authentication. Once connected, users can utilize the Query Editor to create queries.

Uploaded by

Praveen Kumar Gajula
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
21 views2 pages

Introduction To SQL Server Management Studio

SQL Server Management Studio is the primary tool for SQL Server administrators and users to manage and develop databases. To access it, users can navigate through the START menu and connect to the server using either Windows or SQL Server authentication. Once connected, users can utilize the Query Editor to create queries.

Uploaded by

Praveen Kumar Gajula
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

Introduction to SQL Server Management Studio

The SQL Server administrator’s primary tool for interacting with system is SQL
Server Management Studio. Both Admin and end users can use this tool to
administer multiple severs, develop databases.

To open this tool, click START menu, Programs, Microsoft SQL Server2005
and then SQL Server Management Studio then it shows the Connect to Server
Dialog box which appears right after choosing SQL Server management Studio .

1. For Server
type and
Server name
we need not
enter
anything
2. We have 2

authentications in Authentication list box


a. Windows Authentication : you will be connected to SQL Server
using windows account
b. SQL Server Authentication: you will be connected to SQL Server
using own.
Note: Default login name is sa and password is sa123

After connecting to SQL Server ,then it appears as follows


Click on New Query (available under File menu) to get Query Editor in which
you can create queries.

You might also like