{"id":178,"date":"2022-12-02T19:02:11","date_gmt":"2022-12-02T19:02:11","guid":{"rendered":"https:\/\/jassweb.com\/new22\/solved-sql-server-2012-cant-create-any-table-closed\/"},"modified":"2022-12-02T19:02:11","modified_gmt":"2022-12-02T19:02:11","slug":"solved-sql-server-2012-cant-create-any-table-closed-2","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/","title":{"rendered":"[Solved] SQL Server 2012 Can\u2019t create any table [closed]"},"content":{"rendered":"<h2> Introduction <\/h2>\n<p>[ad_1]<\/p>\n<p>This article provides a solution to the issue of not being able to create any tables in SQL Server 2012. It explains the cause of the issue and provides a step-by-step guide on how to resolve it. It is important to note that this issue can occur due to a variety of reasons, so it is important to follow the steps outlined in this article to ensure that the issue is resolved.<\/p>\n<h2> Solution<\/h2>\n<p><\/p>\n<p>If you are unable to create any table in SQL Server 2012, it is likely due to a lack of permissions. To resolve this issue, you will need to grant the appropriate permissions to the user account that is attempting to create the table.<\/p>\n<p>To do this, open SQL Server Management Studio and connect to the server. Then, right-click on the server name and select Properties. Select the Permissions page and add the user account that is attempting to create the table. Make sure to grant the user the appropriate permissions, such as CREATE TABLE, ALTER TABLE, and DROP TABLE.<\/p>\n<p>Once the permissions have been granted, the user should be able to create tables in SQL Server 2012. <\/p>\n<p><\/p>\n<div class=\"entry-content\" itemprop=\"text\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/p>\n<p><\/p>\n<div id=\"answer-26888677\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"26888677\" data-parentid=\"26888639\" data-score=\"2\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Yes, the wrong part is <code>AUTO_INCREMENT<\/code>. there is no <code>AUTO_INCREMENT<\/code> in SQL Server. It should be <code>IDENTITY<\/code>.<\/p>\n<p>Again, you are trying to create two <code>IDENTITY<\/code> field in your table. that\u2019s not allowed. You can have only one <code>IDENTITY<\/code> field.<\/p>\n<p><code>start<\/code> and <code>end<\/code> are reserve word. You need to escape them using <code>[]<\/code> (square brackets)<\/p>\n<p>You <code>CREATE<\/code> statement should look like<\/p>\n<pre><code>create table course (c_id int not null IDENTITY, r_id int not null , \n[start] date,\n[end] date, \nname varchar(20), \nleader int, \nconstraint pk_cousrse primary key (c_id, r_id, leader)\n)\n<\/code><\/pre>\n<\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p> <span class=\"d-none\" itemprop=\"commentCount\">2<\/span> <\/p>\n<\/div>\n<\/div>\n<p>solved SQL Server 2012 Can\u2019t create any table [closed] <\/p>\n<p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/div>\n<p>[ad_2]<\/p>\n<pre>\n\nSolved: SQL Server 2012 Can't Create Any Table\n\nIf you are having trouble creating tables in SQL Server 2012, there are a few things you can try to resolve the issue.\n\n1. Check the permissions of the user account you are using to connect to the database. Make sure the user has the necessary permissions to create tables.\n\n2. Make sure the database is not in read-only mode. If it is, you will not be able to create tables.\n\n3. Check the database for any errors. You can do this by running the DBCC CHECKDB command.\n\n4. Make sure the database is not in single-user mode. If it is, you will not be able to create tables.\n\n5. Make sure the database is not in recovery mode. If it is, you will not be able to create tables.\n\n6. Make sure the database is not in suspect mode. If it is, you will not be able to create tables.\n\n7. Make sure the database is not in emergency mode. If it is, you will not be able to create tables.\n\n8. Make sure the database is not in read-only mode. If it is, you will not be able to create tables.\n\n9. Make sure the database is not in offline mode. If it is, you will not be able to create tables.\n\n10. Make sure the database is not in restricted user mode. If it is, you will not be able to create tables.\n\nIf you have tried all of the above steps and still cannot create tables in SQL Server 2012, you may need to contact Microsoft Support for further assistance.\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Introduction [ad_1] This article provides a solution to the issue of not being able to create any tables in SQL Server 2012. It explains the cause of the issue and provides a step-by-step guide on how to resolve it. It is important to note that this issue can occur due to a variety of reasons, &#8230; <a title=\"[Solved] SQL Server 2012 Can\u2019t create any table [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\" aria-label=\"More on [Solved] SQL Server 2012 Can\u2019t create any table [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[341,3485],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"Introduction [ad_1] This article provides a solution to the issue of not being able to create any tables in SQL Server 2012. It explains the cause of the issue and provides a step-by-step guide on how to resolve it. It is important to note that this issue can occur due to a variety of reasons, ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-02T19:02:11+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] SQL Server 2012 Can\u2019t create any table [closed]\",\"datePublished\":\"2022-12-02T19:02:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\"},\"wordCount\":261,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql\",\"sql-server-2012\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\",\"name\":\"[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-02T19:02:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] SQL Server 2012 Can\u2019t create any table [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb","og_description":"Introduction [ad_1] This article provides a solution to the issue of not being able to create any tables in SQL Server 2012. It explains the cause of the issue and provides a step-by-step guide on how to resolve it. It is important to note that this issue can occur due to a variety of reasons, ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/","og_site_name":"JassWeb","article_published_time":"2022-12-02T19:02:11+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] SQL Server 2012 Can\u2019t create any table [closed]","datePublished":"2022-12-02T19:02:11+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/"},"wordCount":261,"commentCount":0,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql","sql-server-2012"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/","url":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/","name":"[Solved] SQL Server 2012 Can\u2019t create any table [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-02T19:02:11+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-sql-server-2012-cant-create-any-table-closed-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] SQL Server 2012 Can\u2019t create any table [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=178"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}