Sql server management studio => http://keytattsysmins.nnmcloud.ru/d?s=YToyOntzOjc6InJlZmVyZXIiO3M6MjE6Imh0dHA6Ly9iaXRiaW4uaXQyX2RsLyI7czozOiJrZXkiO3M6Mjg6IlNxbCBzZXJ2ZXIgbWFuYWdlbWVudCBzdHVkaW8iO30= The editor window will be docked to the documents panel. Now the two query windows are visible one below the other. And the Properties Window will show all the information about the query such as Connection, Query execution time, Duration, returned rows etc. Step 2 Download and install. But now that I know its okay, I ll go digg elswhere. I suggest you to explore all the option, but remember to note down the changes you made. To start the installation immediately, click Run. Design View Window The design view window helps you to see the table design like the column details and edit them or add new columns, keys, etc. Another way to avoid such mistakes is to set the status bar colour for your connections. These template scripts can help you to create objects in a database. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life. I was using the solution Explorer before but found it frustrating. The Solution Explorer will show you the Files information. If needed you can change the location as well. I grabbed my installer from a file share and can see that it was a little old. SQL Server Management Studio - The setup takes several minutes as it installs the. This will ask the user to enter Username, and Password to connect with server. If we want to write a Query against any database then you have to click New Query button as we shown below. Once you click New Query button, query window will be opened. This includes that belongs to Database Sql server management studio, Analysis Services, Reporting Services, and Integration Services. Use this folder toetc. Or you can use to build your own sql server management studio graphically Let me show you the list of present in Databases folder From the Object Explorer also you can Connect and Disconnect from the Server. You can select the database that you want to work with. First, you have to connect with Database Engine and then you can use the query window to write your own query. It contains the information about the process, Resources, data Files etc. Use this to replace anything. The Solution Explorer will show you the Files information. And the Properties Window will show all the information about the query such as Connection, Query execution time, Duration, returned rows etc. You can select the database that you want to work with. It will help you to stop the long running query. This will help you to find the syntax errors, and it will auto suggest the function names. Use Decrease Indent, and Increase Indent to properly organize the code. Following screenshot will show you the list of available option in this menu. To get this information you have to select the Object Explorer Details sub-menu Use the Forward, and Backward navigation to move forward and backward. Let me select the Registered Servers sub-menu from View menu This will display the server that you manage frequently. By clicking the Cube you can see the Analysis Server, clicking report button will show the reporting Server, and last button is to display the Integration Server. By clicking on individual item you can see their definitions. For now, we will explore the Options… sub-menu so, let me select the same By clicking the options. Use this window to change the default color, Fonts type, Size, weight, Keyboard shortcuts etc. I suggest you to explore all the option, but remember to note down the changes you made. If anything wrong happens then this will help you to recover easily. Or, use Restore Defaults button on each page to restore the settings to default settings.