After successful login ,the following can be done to SQL Server Management Studio.
1)Configuration
2)Backup and Restore of databases
3)Create or Delete of data bases
4)Query execution
5)SQL server email configuration
6)Job Scheduling
7)Database synchronization
8)Create, delete, update of SQL server functions
9)Create,delete ,update stored procedure
10)Create,delete, update triggers
11)Create, delete, update tables
12)Create, delete, update views
SQL Server Management Studio is a integrated several component is associated with the platforms
object Explorer : object Explorer is used to view manage configure administration of objects with the help of a graphical views, context menu etc. It is the most used component of a SQL Server Management Studio. You can connect to the server and choose corresponding databases all create database and expand tree structure of the object Explorer. You can see all database ,table stored procedure, functions , Trigger, views, job and scheduling task here.
Query and Text editor: this editor is used for writing query script and execution and debugging of the query. You can also see execution plan of a query or a stored procedure in this component. You can write query and press F5 to run query or click on Run button, will notice the result will be shown in the below, if any error occur the component will notify you by error message.
Solution Explorer : you can build project on manage project by writing script in the solution Explorer. Implement source control and work with multiple files.
SQL server management studio has a lot of functionality, you can connect to disconnect particular server and corresponding database by login to that server.
You can get output of a query in text format or Grid format or you can export it to the file.
No comments:
Post a Comment