![]() ![]() Visual Database Tools – SSMS includes visual designers to build transact-SQL queries, tables and diagramming databases. Solution Explorer – It can be used to build and manage the administration items such as scripts and queries. ![]() Template Explorer – The template explorer can be used to build and manage files to speed up the development of queries and scripts. Object Explorer – It can be used to view and manage all of the objects in one or more instances of SQL Server. To access SSMS using the command line, Copy the entire path of the ssms.exe and run the following command. There is one more approach to access SSMS, using the command line. Username/Password – If you select anything other than “Windows Authentication”, these two fields will be required. Server Name – It is the name of the server to which the connection will be made.Īuthentication – This will be Windows Authentication as default if we have used “Windows Authentication” during the SQL server installation. The available services are Database Engine, Analysis, Reporting and Integration. Server Type – This is to select one of the four services available. Let us understand what all the fields mentioned in the image are used for. When you open the SQL server management studio from the start menu, a window will open similar to the window shown in the picture below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |