{"id":11312,"date":"2018-12-28T12:02:59","date_gmt":"2018-12-28T14:02:59","guid":{"rendered":"http:\/\/ajuda.locaweb.com.br\/?post_type=ht_kb&#038;p=11312"},"modified":"2019-07-31T15:56:54","modified_gmt":"2019-07-31T18:56:54","slug":"habilitar-e-desabilitar-as-contraints-no-mssql2008","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/habilitar-e-desabilitar-as-contraints-no-mssql2008\/","title":{"rendered":"Habilitar e Desabilitar as contraints no MSSQL2008"},"content":{"rendered":"<p>Se voc\u00ea est\u00e1 precisando habilitar ou desabilitar as constrains no seu banco de dados SQL Server, veja neste procedimento como realizar.<\/p>\n<h6>Verificar o status das constrains do banco<\/h6>\n<pre>SELECT (CASE\r\nWHEN OBJECTPROPERTY(CONSTID, 'CNSTISDISABLED') = 0 THEN 'ENABLED'\r\nELSE 'DISABLED'\r\nEND) AS STATUS,\r\nOBJECT_NAME(CONSTID) AS CONSTRAINT_NAME,\r\nOBJECT_NAME(FKEYID) AS TABLE_NAME,\r\nCOL_NAME(FKEYID, FKEY) AS COLUMN_NAME,\r\nOBJECT_NAME(RKEYID) AS REFERENCED_TABLE_NAME,\r\nCOL_NAME(RKEYID, RKEY) AS REFERENCED_COLUMN_NAME\r\nFROM SYSFOREIGNKEYS\r\nORDER BY TABLE_NAME, CONSTRAINT_NAME,REFERENCED_TABLE_NAME, KEYNO<\/pre>\n<h6>Desabilita todas as constrains<\/h6>\n<pre>EXEC sp_msforeachtable \"ALTER TABLE ? NOCHECK CONSTRAINT all\"<\/pre>\n<h6>Habilitando Todas as Constraints<\/h6>\n<pre>exec sp_msforeachtable @command1=\"print '?'\"\r\n, @command2=\"ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all\"<\/pre>\n<h6>Alterando a propriedade Identily de uma chave<\/h6>\n<p>Caso editar uma tabela apresente o erro:\u00a0&#8220;<strong>Failure inserting into the read-only column ColumnName<\/strong>&#8220;.<\/p>\n<ul>\n<li>Realize o procedimento de alterar propriedade da chave;<\/li>\n<li>Acesse a base pelo <strong>Management Studio<\/strong>;<\/li>\n<li>Clique na <strong>base<\/strong> e seguida em <strong>Tables<\/strong>;<\/li>\n<li>Em seguinda expanda o <strong>dbo.AWBuildVersion<\/strong>;<\/li>\n<li>Depois expanda <strong>Keys<\/strong>, clique com bot\u00e3o direito do mouse em <strong>PK_AWBuildVersion\u00a0<\/strong>e seguinda clique no <strong>Modify<\/strong>;<\/li>\n<li>Do seu lado esquerdo procure por <strong>Identity Specification<\/strong>, mude o valor de <strong>YES<\/strong> para <strong>NO<\/strong>;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11313 size-full\" src=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7.jpg\" alt=\"\" width=\"703\" height=\"497\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7.jpg 703w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7-300x212.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7-50x35.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7-60x42.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2018\/12\/Ident7-100x71.jpg 100w\" sizes=\"auto, (max-width: 703px) 100vw, 703px\" \/><\/p>\n<ul>\n<li>Depois clique em <strong>Salvar<\/strong>.<\/li>\n<\/ul>\n<p>Aproveite e conhe\u00e7a outros produtos da Locaweb, como o Cloud Hosting, <a href=\"https:\/\/www.locaweb.com.br\/cloud\/cloud-hosting\/\" target=\"_blank\" rel=\"noopener noreferrer\">clique aqui<\/a> e saiba mais!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Se voc\u00ea est\u00e1 precisando habilitar ou desabilitar as constrains no seu banco de dados SQL Server, veja neste procedimento como realizar. Verificar o status das constrains do banco SELECT (CASE WHEN OBJECTPROPERTY(CONSTID, &#8216;CNSTISDISABLED&#8217;) = 0 THEN &#8216;ENABLED&#8217; ELSE &#8216;DISABLED&#8217; END) AS STATUS, OBJECT_NAME(CONSTID) AS CONSTRAINT_NAME, OBJECT_NAME(FKEYID) AS TABLE_NAME, COL_NAME(FKEYID, FKEY)&#8230;<\/p>\n","protected":false},"author":232,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[418],"class_list":["post-11312","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_tag-categoriahospedagem"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/11312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/232"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=11312"}],"version-history":[{"count":2,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/11312\/revisions"}],"predecessor-version":[{"id":17574,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/11312\/revisions\/17574"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=11312"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=11312"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=11312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}