{"id":2494,"date":"2025-09-17T21:18:00","date_gmt":"2025-09-17T21:18:00","guid":{"rendered":"https:\/\/www.mainmind.com\/blog\/?p=2494"},"modified":"2026-02-17T21:25:27","modified_gmt":"2026-02-17T21:25:27","slug":"tip-auditar-y-actualizar-instancias-sql","status":"publish","type":"post","link":"https:\/\/www.mainmind.com\/blog\/tip-auditar-y-actualizar-instancias-sql\/","title":{"rendered":"TIP: Auditar y actualizar instancias SQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Auditar todas las bases de datos de usuario y detectar si utilizan Full-Text Search, por ejemplo para saber que opci\u00f3n elegir al actualizar instancias de SQL Server:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"793\" height=\"438\" src=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2025\/SQL_fulltext_update.jpg\" alt=\"SQL_fulltext_update sobre 2025\" class=\"wp-image-2495\" srcset=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2025\/SQL_fulltext_update.jpg 793w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2025\/SQL_fulltext_update-300x166.jpg 300w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2025\/SQL_fulltext_update-768x424.jpg 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/figure>\n<\/div>\n\n\n<!--more-->\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSET NOCOUNT ON;\n\nIF OBJECT_ID(&#039;tempdb..#FullTextAudit&#039;) IS NOT NULL\n    DROP TABLE #FullTextAudit;\n\nCREATE TABLE #FullTextAudit\n(\n    DatabaseName sysname,\n    HasFullText bit,\n    CatalogCount int,\n    IndexCount int\n);\n\nDECLARE @db sysname;\nDECLARE @sql nvarchar(max);\n\nDECLARE db_cursor CURSOR FAST_FORWARD FOR\nSELECT name\nFROM sys.databases\nWHERE database_id &gt; 4        -- Excluye master, model, msdb, tempdb\nAND state = 0;               -- Solo bases ONLINE\n\nOPEN db_cursor;\nFETCH NEXT FROM db_cursor INTO @db;\n\nWHILE @@FETCH_STATUS = 0\nBEGIN\n    SET @sql = &#039;\n    USE &#x5B;&#039; + @db + &#039;];\n\n    INSERT INTO #FullTextAudit (DatabaseName, HasFullText, CatalogCount, IndexCount)\n    SELECT\n        DB_NAME(),\n        CASE WHEN COUNT(DISTINCT c.fulltext_catalog_id) &gt; 0 THEN 1 ELSE 0 END,\n        COUNT(DISTINCT c.fulltext_catalog_id),\n        COUNT(DISTINCT i.object_id)\n    FROM sys.fulltext_catalogs c\n    FULL OUTER JOIN sys.fulltext_indexes i\n        ON c.fulltext_catalog_id = i.fulltext_catalog_id;\n    &#039;;\n\n    EXEC sp_executesql @sql;\n\n    FETCH NEXT FROM db_cursor INTO @db;\nEND\n\nCLOSE db_cursor;\nDEALLOCATE db_cursor;\n\n-- Resultado resumen\nSELECT *\nFROM #FullTextAudit\nORDER BY HasFullText DESC, DatabaseName;\n\n-- Resumen final\nSELECT \n    SUM(CASE WHEN HasFullText = 1 THEN 1 ELSE 0 END) AS DatabasesWithFullText,\n    COUNT(*) AS TotalDatabases\nFROM #FullTextAudit;\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Si no aparece ninguna puedes seleccionar \u00abImportar\u00bb no tendr\u00e1 ning\u00fan efecto&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Auditar todas las bases de datos de usuario y detectar si utilizan Full-Text Search, por ejemplo para saber que opci\u00f3n elegir al actualizar instancias de SQL Server:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[1019,178,1020],"class_list":["post-2494","post","type-post","status-publish","format-standard","hentry","category-bases-de-datos","tag-fulltext","tag-sql-server","tag-texto-completo"],"_links":{"self":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/2494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/comments?post=2494"}],"version-history":[{"count":1,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/2494\/revisions"}],"predecessor-version":[{"id":2496,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/2494\/revisions\/2496"}],"wp:attachment":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media?parent=2494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/categories?post=2494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/tags?post=2494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}