{"id":6591,"date":"2024-01-29T05:51:00","date_gmt":"2024-01-29T04:51:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6591"},"modified":"2023-11-08T10:50:10","modified_gmt":"2023-11-08T09:50:10","slug":"create-sql-server-database-with-ssms","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/","title":{"rendered":"How To Create a SQL Server Database with SSMS ?"},"content":{"rendered":"\n<p class=\"has-text-align-left\"><em><strong>Step by step tutorial to create a SQL Server database using SSMS (SQL Server Management Studio).<\/strong><\/em><\/p>\n\n\n\n<p>How to create a SQL Server database with SQL Server Management Studio, i.e. SSMS. In this tutorial, let&#8217;s learn how to add a new MS SQL database to an instance. Indeed, to start, it&#8217;s mandatory to create a database to create and use SQL objects. It is possible to perform almost all possible operations on a SQL Server database from SSMS, here it is <a href=\"https:\/\/expert-only.com\/en\/ssms\/download-ssms-18\/\">SQL Server Management Studio 18<\/a>. To install a database instance on your machine, start by installing SQL Server 2017 or 2019 for example.<\/p>\n\n\n\n<p>To <a href=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/\">create a database with a T-SQL script<\/a> check this tutorial with examples of code. Both options are valuable, once automating the deployments then the scripting option is the one to choose. Especially with multiple databases in <a href=\"https:\/\/aws.amazon.com\/en\/devops\/what-is-devops\/\" target=\"_blank\" rel=\"noreferrer noopener\">fast changing environments like DevOps<\/a> project deployment methodology for example.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#1-open-ssms-and-the-new-database-menu\" >1. Open SSMS and the new database menu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#2-configure-the-database-options\" >2. Configure the database options<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#3-video-tutorial-to-create-the-ms-sql-database\" >3. Video tutorial to create the MS SQL database<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#conclusion-on-database-creation-with-ssms\" >Conclusion on database creation with SSMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#more-sql-server-tutorials-to-manage-databases\" >More SQL Server tutorials to manage databases<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-open-ssms-and-the-new-database-menu\"><span class=\"ez-toc-section\" id=\"1-open-ssms-and-the-new-database-menu\"><\/span>1. Open SSMS and the new database menu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, from the PC or the Windows Server, to open SQL Server Management Studio, follow these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <em>Program Files<\/em><\/li>\n\n\n\n<li>Select <em>Microsoft SQL Server<\/em><\/li>\n\n\n\n<li>And then <em><strong>Microsoft SQL Server Management Studio<\/strong><\/em><\/li>\n<\/ul>\n\n\n\n<p>There might be a list of existing databases in the DBMS (Database Management System), at least the system database. If the current privileges are high enough to see them. Connect to the target instance, here it is the <em>localhost<\/em> server, and a SQL Server Authentication.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"345\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication.png\" alt=\"Connect to the database server to create the database in SQL Server Management Studio.\" class=\"wp-image-6560\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication.png 480w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication-300x216.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><figcaption class=\"wp-element-caption\"><strong>Connect to the database server to create the database<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>In <a href=\"https:\/\/fr.wikipedia.org\/wiki\/SQL_Server_Management_Studio\" target=\"_blank\" rel=\"noreferrer noopener\">SSMS<\/a>, follow these steps to create the database: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the instance : <em>localhost<\/em><\/li>\n\n\n\n<li>Then right-click on <em>Databases<\/em><\/li>\n\n\n\n<li>And select the <em>New Database..<\/em><strong><em>.<\/em><\/strong> option in the contextual menu.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"552\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio.png\" alt=\"Right-Click to open the New Database menu on SSMS\" class=\"wp-image-6565\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio.png 604w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio-300x274.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><figcaption class=\"wp-element-caption\">Right-Click to open the New Database menu<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-configure-the-database-options\"><span class=\"ez-toc-section\" id=\"2-configure-the-database-options\"><\/span>2. Configure the database options<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Secondly, in the <em>New Database<\/em> window enter the name of the new SQL Server database. We call the database <strong><em>DB2_ExpertOnly<\/em><\/strong>. Because other databases are already created on the server. In this example, the default settings are kept, for example: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <em>Initial size<\/em> of the database (5 megabytes) and the size of the log file (1 megabyte).<\/li>\n\n\n\n<li>The <em>Autogrowth<\/em> and <em>Maxsize<\/em> options per default are respectively 10 percent and unlimited. <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"689\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation.png\" alt=\"Create the database name and leave the default SSMS options\" class=\"wp-image-6574\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation.png 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation-300x295.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">Create the database name and leave the default SSMS options<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-video-tutorial-to-create-the-ms-sql-database\"><span class=\"ez-toc-section\" id=\"3-video-tutorial-to-create-the-ms-sql-database\"><\/span>3. Video tutorial to create the MS SQL database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The SSMS tutorial on how to create a database is also available in a video format on our Youtube channel. This video expose 3 different ways to create a SQL Server database:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Using the SSMS GUI (Graphical User Intefacer)<\/li>\n\n\n\n<li>Using the Generate Script option from the right click on an existing database.<\/li>\n\n\n\n<li>Using a simple CREATE DATABASE statement script.<\/li>\n<\/ol>\n\n\n\n<div style=\"text-align: center;\">\n<iframe loading=\"lazy\" width=\"426\" height=\"240\" src=\"https:\/\/www.youtube.com\/embed\/PyuMLIsvwQ8?si=jqBZLlIVa5J8K3mB\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion-on-database-creation-with-ssms\"><span class=\"ez-toc-section\" id=\"conclusion-on-database-creation-with-ssms\"><\/span>Conclusion on database creation with SSMS <span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This example shows how to easily create a new SQL Server database from the graphic user interface, also called GUI, with no lines of code. This applies to all existing versions, with some variations in the options and display.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-more-sql-server-tutorials-to-manage-databases\"><span class=\"ez-toc-section\" id=\"more-sql-server-tutorials-to-manage-databases\"><\/span>More SQL Server tutorials to manage databases<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/\">Create a SQL Server database with a T-SQL script<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/delete-sql-server-database-with-a-script\/\">Delete SQL Server database with a script<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/install-a-second-instance-of-sql-server\/\">Install a second instance of SQL Server.<\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Ojs1lsfpxq\"><a href=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/\">Create a SQL Server database with a script<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Create a SQL Server database with a script&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/embed\/#?secret=04hjpYNVsU#?secret=Ojs1lsfpxq\" data-secret=\"Ojs1lsfpxq\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Step by step tutorial to create a SQL Server database using SSMS (SQL Server Management Studio). How to create a SQL Server database with SQL Server Management Studio, i.e. SSMS. In this tutorial, let&#8217;s learn how to add a <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\" title=\"How To Create a SQL Server Database with SSMS ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":28830,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[488],"tags":[],"class_list":{"0":"post-6591","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-dba"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create a SQL Server Database with SSMS ? DBA<\/title>\n<meta name=\"description\" content=\"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create a SQL Server Database with SSMS ?\" \/>\n<meta property=\"og:description\" content=\"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-29T04:51:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1792\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How To Create a SQL Server Database with SSMS ?\",\"datePublished\":\"2024-01-29T04:51:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\"},\"wordCount\":514,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg\",\"articleSection\":[\"SQL Server DBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\",\"url\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\",\"name\":\"How To Create a SQL Server Database with SSMS ? DBA\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg\",\"datePublished\":\"2024-01-29T04:51:00+00:00\",\"description\":\"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg\",\"width\":1792,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create a SQL Server Database with SSMS ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How To Create a SQL Server Database with SSMS ? DBA","description":"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/","og_locale":"en_US","og_type":"article","og_title":"How To Create a SQL Server Database with SSMS ?","og_description":"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.","og_url":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-01-29T04:51:00+00:00","og_image":[{"width":1792,"height":1024,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How To Create a SQL Server Database with SSMS ?","datePublished":"2024-01-29T04:51:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/"},"wordCount":514,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg","articleSection":["SQL Server DBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/","url":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/","name":"How To Create a SQL Server Database with SSMS ? DBA","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg","datePublished":"2024-01-29T04:51:00+00:00","description":"To create a SQL Server database with SSMS and with no SQL code, connect to the server and instance and enter the creation menu.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/3-methods-to-create-a-sql-server-database.jpg","width":1792,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/dba\/create-sql-server-database-with-ssms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How To Create a SQL Server Database with SSMS ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=6591"}],"version-history":[{"count":6,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6591\/revisions"}],"predecessor-version":[{"id":28850,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6591\/revisions\/28850"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/28830"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=6591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=6591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=6591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}