{"id":130,"date":"2018-08-18T08:55:00","date_gmt":"2018-08-18T08:55:00","guid":{"rendered":"https:\/\/www.mainmind.com\/blog\/?p=130"},"modified":"2020-07-27T06:40:23","modified_gmt":"2020-07-27T06:40:23","slug":"microsoft-sql-server-management-studio-cache-is-out-of-date","status":"publish","type":"post","link":"https:\/\/www.mainmind.com\/blog\/microsoft-sql-server-management-studio-cache-is-out-of-date\/","title":{"rendered":"Microsoft SQL Server Management Studio: cache is out of date"},"content":{"rendered":"<p>Es agosto, el software tambien necesita vacaciones&#8230;<\/p>\n<p><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/\/2018\/MSSMS_error_cache.JPG\" alt=\"\"><\/p>\n<p>Si durante las consultas a algunas tablas en MSSMS aparece el error \u00abThe Visual Studio componente cache is out of date\u00bb la soluci\u00f3n r\u00e1pida y sencilla pasa por vaciar la carpeta temporales de windows %TMP%<\/p>\n<pre class=\"brush:bash;auto-links:false;toolbar:false\" contenteditable=\"false\">C:\\Users\\nombre_usuario_windows\\AppData\\Local\\Temp\\<\/pre>\n<p>Si adem\u00e1s el servidor SQL esta en medio de la playa mientras tu sigues programando, puedes probar a seguir con la limpieza de m\u00e1s memorias intermedias, si utilizas Server 2016 o Azure puedes<a href=\"https:\/\/docs.microsoft.com\/es-es\/sql\/t-sql\/statements\/alter-database-scoped-configuration-transact-sql?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\"> limpiar la cache de los procedimientos de la base de datos<\/a>:<\/p>\n<pre class=\"brush:sql;auto-links:false;toolbar:false\" contenteditable=\"false\">USE NombreDeMiBBDD;\nGO\nALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;<\/pre>\n<p>&nbsp;<\/p>\n<p>Mientras esperas que la consulta devuelva los valores esperados ;D<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Es agosto, el software tambien necesita vacaciones&#8230; Si durante las consultas a algunas tablas en MSSMS aparece el error \u00abThe Visual Studio componente cache is out of date\u00bb la soluci\u00f3n r\u00e1pida y sencilla pasa por vaciar la carpeta temporales de windows %TMP% C:\\Users\\nombre_usuario_windows\\AppData\\Local\\Temp\\ Si adem\u00e1s el servidor SQL esta en medio de la playa mientras [&hellip;]<\/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":[299,300,178],"class_list":["post-130","post","type-post","status-publish","format-standard","hentry","category-bases-de-datos","tag-cache-is-out-of-date","tag-management-studio","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/130","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=130"}],"version-history":[{"count":0,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}