{"id":1624,"date":"2023-07-14T07:03:00","date_gmt":"2023-07-14T05:03:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=1624"},"modified":"2023-09-18T14:07:44","modified_gmt":"2023-09-18T12:07:44","slug":"impossible-supprimer-base-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/","title":{"rendered":"Impossible de supprimer la base de donn\u00e9es en cours d&rsquo;utilisation"},"content":{"rendered":"\n<p>Comment \u00e9viter l&rsquo;erreur impossible de supprimer la base de donn\u00e9es avec SQL Server ? Ou simplement l&rsquo;erreur SQL Server 3702. Il est possible de g\u00e9rer les bases de donn\u00e9es SQL avec des scripts ou via les diff\u00e9rentes fen\u00eatres de SQL Server Management Studio. Par exemple, vous pouvez simplement supprimer une base de donn\u00e9es avec une commande SQL DROP DATABASE.<\/p>\n\n\n\n<p>Cependant, s&rsquo;il existe des connexions actives sur la base de donn\u00e9es \u00e0 supprimer, celle-ci renvoie un message d&rsquo;erreur, car une base de donn\u00e9es avec une connexion active ne peut pas \u00eatre supprim\u00e9e.<\/p>\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\/fr\/dba\/impossible-supprimer-base-sql-server\/#1-script-de-suppression-de-base-sql-server-qui-genere-lerreur-3702\" >1. Script de suppression de base SQL Server qui g\u00e9n\u00e8re l&rsquo;erreur 3702<\/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\/fr\/dba\/impossible-supprimer-base-sql-server\/#2-executer-la-commande-sp-who2-pour-identifier-les-sessions-actives\" >2. Ex\u00e9cuter la commande sp_who2 pour identifier les sessions actives<\/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\/fr\/dba\/impossible-supprimer-base-sql-server\/#3-fermer-les-sessions-actives-avec-la-commande-sql-server-kill\" >3. Fermer les sessions actives avec la commande SQL Server kill<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#4-repetez-loperation-pour-toutes-les-connexions-sql-actives\" >4. R\u00e9p\u00e9tez l&rsquo;op\u00e9ration pour toutes les connexions SQL actives<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-script-de-suppression-de-base-sql-server-qui-genere-l-erreur-3702\"><span class=\"ez-toc-section\" id=\"1-script-de-suppression-de-base-sql-server-qui-genere-lerreur-3702\"><\/span>1. Script de suppression de base SQL Server qui g\u00e9n\u00e8re l&rsquo;erreur 3702<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Le texte exact du message d&rsquo;erreur est celui-ci : \u00ab\u00a0Impossible de supprimer la base de donn\u00e9es car elle est actuellement en cours d&rsquo;utilisation. (Microsoft SQL Server, Erreur : 3702)\u00a0\u00bb. Le message d&rsquo;erreur en Anglais est : \u00ab\u00a0Cannot drop the database because it is currently in use\u00a0\u00bb.<\/p>\n\n\n\n<p><strong>Note : Prenez soin de v\u00e9rifier les sauvegardes de la base de donn\u00e9es avant de la supprimer compl\u00e8tement. Surtout dans les projets importants et les environnements de production.<\/strong><\/p>\n\n\n\n<p>Ce type de script g\u00e9n\u00e8re l&rsquo;erreur :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">USE [master];\nGO\n\nDROP DATABASE [DB1];\nGO\n<\/pre>\n\n\n\n<p>Une autre m\u00e9thode consiste \u00e0 v\u00e9rifier l&rsquo;existence de la base de donn\u00e9es sur le serveur, avant d&rsquo;ex\u00e9cuter la commande Drop Database, comme ceci par exemple :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">USE [master];\nGO\n\nIF EXISTS (\n   SELECT name \n   FROM master.dbo.sysdatabases\n   WHERE name = 'DB1'\n)\nDROP DATABASE [DB1];\nGO\n<\/pre>\n\n\n\n<p>Pour \u00e9viter cette erreur, fermez toutes les connexions actives \u00e0 la base de donn\u00e9es avant le d\u00e9p\u00f4t et terminez les requ\u00eates en cours. Ensuite, fermez les onglets dans SSMS ou terminez explicitement les connexions ouvertes sur la base de donn\u00e9es. Enfin, fermez les onglets actifs si un seul utilisateur est actuellement connect\u00e9.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-executer-la-commande-sp-who2-pour-identifier-les-sessions-actives\"><\/span>2. Ex\u00e9cuter la commande sp_who2 pour identifier les sessions actives<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans la capture d&rsquo;\u00e9cran, nous identifions les sessions actives pour la base de donn\u00e9es <strong>DB1<\/strong>. Nous voyons un utilisateur avec le <strong>SPID 51<\/strong>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">sp_who2;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"295\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\" alt=\"Utiliser la commande sp_who2 pour corriger l'erreur SQL Server 3702 Impossible de supprimer la base de donn\u00e9es\" class=\"wp-image-6610\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png 849w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid-300x104.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid-768x267.png 768w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/><figcaption class=\"wp-element-caption\">Utiliser la commande sp_who2 pour corriger l&rsquo;erreur SQL Server 3702 Impossible de supprimer la base de donn\u00e9es<\/figcaption><\/figure><\/div>\n\n\n<p><strong>Cet autre article explique <a href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-avec-ssms\/\">comment cr\u00e9er une base de donn\u00e9es avec SSMS<\/a> simplement depuis l&rsquo;interface graphique utilisateur et avec les options par d\u00e9faut.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-fermer-les-sessions-actives-avec-la-commande-sql-server-kill\"><\/span>3. Fermer les sessions actives avec la commande SQL Server kill<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">kill 51\n<\/pre>\n\n\n\n<p>Modifier la requ\u00eate avec les num\u00e9ros SPID trouv\u00e9s dans votre base. La <a href=\"https:\/\/blog.ansi.org\/sql-standard-iso-iec-9075-2023-ansi-x3-135\/#gref\" target=\"_blank\" rel=\"noreferrer noopener\">commande SQL<\/a> kill permet d&rsquo;\u00e9viter l&rsquo;erreur <strong>SQL Server 3702<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"283\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/12\/sql_server_command_kill_spid_active_session.png\" alt=\"Utilisez la requ\u00eate kill pour mettre fin aux sessions et r\u00e9gler l'erreur 3702 Impossible de supprimer la base de donn\u00e9es\" class=\"wp-image-6616\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/12\/sql_server_command_kill_spid_active_session.png 701w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/12\/sql_server_command_kill_spid_active_session-300x121.png 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><figcaption class=\"wp-element-caption\">Utilisez la requ\u00eate kill pour mettre fin aux sessions et r\u00e9gler l&rsquo;erreur 3702 Impossible de supprimer la base de donn\u00e9es<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-repetez-l-operation-pour-toutes-les-connexions-sql-actives\"><span class=\"ez-toc-section\" id=\"4-repetez-loperation-pour-toutes-les-connexions-sql-actives\"><\/span>4. R\u00e9p\u00e9tez l&rsquo;op\u00e9ration pour toutes les connexions SQL actives<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Maintenant la base de donn\u00e9es est supprim\u00e9e sans message d&rsquo;erreur. Le but ici est de terminer toutes les sessions active pour pouvoir supprimer la base.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h3>\n\n\n\n<p>Cet article a expliqu\u00e9 comment \u00e9viter un message d&rsquo;erreur courant de SQL Server: Impossible de supprimer la base de donn\u00e9es car elle est actuellement en cours d&rsquo;utilisation. Pour aller plus loin, voici la documentation officielle de la commande T-SQL <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/t-sql\/language-elements\/kill-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">kill<\/a>. En effet, il s&rsquo;agit d&rsquo;un objet qui permet de nombreuses connexions de diff\u00e9rents utilisateurs en m\u00eame temps.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1649417043260\"><strong class=\"schema-faq-question\">Comment effacer compl\u00e8tement une base de donn\u00e9es SQL Server ?<\/strong> <p class=\"schema-faq-answer\">Une base de donn\u00e9es, contrairement \u00e0 une table ne s&rsquo;efface pas. Une base de donn\u00e9es doit \u00eatre supprim\u00e9e pour en effacer tout le contenu. Utiliser la commande DROP DATABASE pour supprimer une base de donn\u00e9es SQL Server.<\/p> <\/div> <\/div>\n\n\n\n<p><strong>Pour aller plus loin et en savoir plus sur les bases de donn\u00e9es. Voici comment <a href=\"https:\/\/expert-only.com\/fr\/dba\/installer-une-deuxieme-instance\/\">installer une deuxi\u00e8me instance SQL Server<\/a> sur le m\u00eame serveur.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"8R88wK0jtT\"><a href=\"https:\/\/expert-only.com\/fr\/dba\/installer-une-deuxieme-instance\/\">Installer une deuxi\u00e8me instance SQL Server<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Installer une deuxi\u00e8me instance SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/dba\/installer-une-deuxieme-instance\/embed\/#?secret=aCKVffxyEe#?secret=8R88wK0jtT\" data-secret=\"8R88wK0jtT\" 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>Comment \u00e9viter l&rsquo;erreur impossible de supprimer la base de donn\u00e9es avec SQL Server ? Ou simplement l&rsquo;erreur SQL Server 3702. Il est possible de g\u00e9rer les bases de donn\u00e9es SQL avec des scripts ou via les diff\u00e9rentes fen\u00eatres de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\" title=\"Impossible de supprimer la base de donn\u00e9es en cours d&rsquo;utilisation\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352],"tags":[],"class_list":{"0":"post-1624","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"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>Impossible de supprimer la base de donn\u00e9es en cours d&#039;utilisation<\/title>\n<meta name=\"description\" content=\"M\u00e9thode pour corriger l&#039;erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d&#039;utilisation.\" \/>\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\/fr\/dba\/impossible-supprimer-base-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Impossible de supprimer la base de donn\u00e9es en cours d&#039;utilisation\" \/>\n<meta property=\"og:description\" content=\"M\u00e9thode pour corriger l&#039;erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T05:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-18T12:07:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\" \/>\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=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\/fr\/dba\/impossible-supprimer-base-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Impossible de supprimer la base de donn\u00e9es en cours d&rsquo;utilisation\",\"datePublished\":\"2023-07-14T05:03:00+00:00\",\"dateModified\":\"2023-09-18T12:07:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\"},\"wordCount\":628,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\",\"articleSection\":[\"Administration SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\",\"name\":\"Impossible de supprimer la base de donn\u00e9es en cours d'utilisation\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\",\"datePublished\":\"2023-07-14T05:03:00+00:00\",\"dateModified\":\"2023-09-18T12:07:44+00:00\",\"description\":\"M\u00e9thode pour corriger l'erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260\"}],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Impossible de supprimer la base de donn\u00e9es en cours d&#8217;utilisation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/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\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260\",\"name\":\"Comment effacer compl\u00e8tement une base de donn\u00e9es SQL Server ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Une base de donn\u00e9es, contrairement \u00e0 une table ne s'efface pas. Une base de donn\u00e9es doit \u00eatre supprim\u00e9e pour en effacer tout le contenu. Utiliser la commande DROP DATABASE pour supprimer une base de donn\u00e9es SQL Server.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Impossible de supprimer la base de donn\u00e9es en cours d'utilisation","description":"M\u00e9thode pour corriger l'erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d'utilisation.","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\/fr\/dba\/impossible-supprimer-base-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Impossible de supprimer la base de donn\u00e9es en cours d'utilisation","og_description":"M\u00e9thode pour corriger l'erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d'utilisation.","og_url":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-07-14T05:03:00+00:00","article_modified_time":"2023-09-18T12:07:44+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png","type":"","width":"","height":""}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Impossible de supprimer la base de donn\u00e9es en cours d&rsquo;utilisation","datePublished":"2023-07-14T05:03:00+00:00","dateModified":"2023-09-18T12:07:44+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/"},"wordCount":628,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png","articleSection":["Administration SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/","url":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/","name":"Impossible de supprimer la base de donn\u00e9es en cours d'utilisation","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png","datePublished":"2023-07-14T05:03:00+00:00","dateModified":"2023-09-18T12:07:44+00:00","description":"M\u00e9thode pour corriger l'erreur SQL Server 3702, impossible de supprimer la base de donn\u00e9es car elle est en cours d'utilisation.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260"}],"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/sql_server_command_sp_who2_check_spid.png"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Impossible de supprimer la base de donn\u00e9es en cours d&#8217;utilisation"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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\/fr\/#\/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\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/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"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260","position":1,"url":"https:\/\/expert-only.com\/fr\/dba\/impossible-supprimer-base-sql-server\/#faq-question-1649417043260","name":"Comment effacer compl\u00e8tement une base de donn\u00e9es SQL Server ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Une base de donn\u00e9es, contrairement \u00e0 une table ne s'efface pas. Une base de donn\u00e9es doit \u00eatre supprim\u00e9e pour en effacer tout le contenu. Utiliser la commande DROP DATABASE pour supprimer une base de donn\u00e9es SQL Server.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1624"}],"version-history":[{"count":11,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1624\/revisions"}],"predecessor-version":[{"id":27023,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1624\/revisions\/27023"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}