![\"checkdb_without_tables\"](\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/12\/checkdb_without_tables.png?resize=678%2C240\")
<\/a><\/p>\nAl\u00e9m das procedures sp_MSforeachdb e sp_MSforeachtable existem outras procedures n\u00e3o documentadas como as da lista abaixo, n\u00e3o existe suporte ou material oficial\u00a0que ensine a utiliz\u00e1-la por parte da Microsoft.<\/p>\n
sp_checknames
\nsp_columns_rowset
\nsp_enumoledbdatasources
\nsp_fixindex
\nsp_gettypestring
\nsp_ms_marksystemobject
\nsp_msaddguidcolumn
\nsp_msaddguidindex
\nsp_msaddlogin_implicit_ntlogin
\nsp_msadduser_implicit_ntlogin
\nsp_mscheck_uid_owns_anything
\nsp_msdbuseraccess
\nsp_msdbuserpriv
\nsp_msdependencies
\nsp_msdrop_object
\nsp_msforeachdb
\nsp_msforeachtable
\nsp_msget_qualified_name
\nsp_msgettools_path
\nsp_msgetversion
\nsp_msguidtostr
\nsp_mshelpcolumns
\nsp_mshelpindex
\nsp_mshelptype
\nsp_msindexspace
\nsp_msis_pk_col
\nsp_mskilldb
\nsp_msloginmappings
\nsp_mstablekeys
\nsp_mstablerefs
\nsp_mstablespace
\nsp_msunc_to_drive
\nsp_msuniquecolname
\nsp_msuniquename
\nsp_msuniqueobjectname
\nsp_msuniquetempname
\nsp_tempdbspace
\nsp_who2
\nxp_delete_file
\nxp_dirtree
\nxp_enum_oledb_providers
\nxp_enumcodepages
\nxp_enumdsn
\nxp_enumerrorlogs
\nxp_enumgroups
\nxp_fileexist
\nxp_fixeddrives
\nxp_get_mapi_default_profile
\nxp_get_mapi_profiles
\nxp_getnetname
\nxp_qv
\nxp_readerrorlog
\nxp_regaddmultistring
\nxp_regdeletekey
\nxp_regdeletevalue
\nxp_regenumvalues
\nxp_regread
\nxp_regremovemultistring
\nxp_regwrite
\nxp_subdirs
\nxp_varbintohexstr<\/p>\n
Bom por hoje \u00e9 isso.<\/p>\n
Um abra\u00e7o,<\/p>\n
Tiago Neves<\/p>\n","protected":false},"excerpt":{"rendered":"
Ol\u00e1 pessoal, No post de hoje vou falar sobre as procedures n\u00e3o documentadas do SQL Server sp_MSforeachdb e sp_MSforeachtable, elas s\u00e3o muito \u00fateis quando voc\u00ea se deparar com uma atividade, em que voc\u00ea necessite buscar as informa\u00e7\u00f5es em todos os bancos de dados ou todas as tabelas.\u00a0Essas procedures executam atividades em loop atrav\u00e9s dos bancos […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_91251433_91251433":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Procedures n\u00e3o documentadas sp_MSforeachdb e sp_MSforeachtable","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpscppro_dont_share_socialmedia":false,"_wpscppro_custom_social_share_image":0,"_facebook_share_type":"","_twitter_share_type":"","_linkedin_share_type":"","_pinterest_share_type":"","_linkedin_share_type_page":"","_instagram_share_type":"","_medium_share_type":"","_threads_share_type":"","_google_business_share_type":"","_selected_social_profile":[],"_wpsp_enable_custom_social_template":false,"_wpsp_social_scheduling":{"enabled":false,"datetime":null,"platforms":[],"status":"template_only","dateOption":"today","timeOption":"now","customDays":"","customHours":"","customDate":"","customTime":"","schedulingType":"absolute"},"_wpsp_active_default_template":true},"categories":[2,4,20,5],"tags":[96,14],"class_list":["post-362","post","type-post","status-publish","format-standard","hentry","category-casos-do-dia-a-dia","category-scripts","category-sqlserver-geral","category-virtual-pass-br","tag-loop","tag-sqlserver"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6eIyh-5Q","jetpack-related-posts":[{"id":2414,"url":"https:\/\/www.tiagoneves.net\/blog\/sql-server-2016-esta-chegando-ao-fim-do-suporte-o-que-isso-significa-na-pratica\/","url_meta":{"origin":362,"position":0},"title":"SQL Server 2016 est\u00e1 chegando ao fim do suporte: o que isso significa na pr\u00e1tica?","author":"tiagoneves","date":"27 de abril de 2026","format":false,"excerpt":"O SQL Server 2016 ter\u00e1 seu suporte estendido encerrado em 14 de julho de 2026, o que resultar\u00e1 na falta de atualiza\u00e7\u00f5es de seguran\u00e7a e suporte. Continuar usando essa vers\u00e3o traz riscos como vulnerabilidades e n\u00e3o conformidade regulat\u00f3ria. Planejar a migra\u00e7\u00e3o para vers\u00f5es mais recentes ou cloud deve ser prioridade\u2026","rel":"","context":"Em "Seguran\u00e7a"","block_context":{"text":"Seguran\u00e7a","link":"https:\/\/www.tiagoneves.net\/blog\/category\/seguranca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/comments?post=362"}],"version-history":[{"count":5,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/362\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media?parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/categories?post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/tags?post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"procedure_MSforeachdb\"](\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2015\/12\/procedure_MSforeachdb.png\")
<\/a><\/p>\n