Skip to content

Instantly share code, notes, and snippets.

@roman-yagodin

roman-yagodin/dnn_update_cache_time.sql

Last active May 18, 2017 10:16
Show Gist options
  • Save roman-yagodin/95c7af2a907c00b5c3d94d7cd4cf4d42 to your computer and use it in GitHub Desktop.
Save roman-yagodin/95c7af2a907c00b5c3d94d7cd4cf4d42 to your computer and use it in GitHub Desktop.
Download ZIP
DNN: Update cache time of modules by definition name
Raw
dnn_update_cache_time.sql
UPDATE {databaseOwner}[{objectQualifier}TabModules] SET CacheTime = 0 WHERE ModuleID IN (
select ModuleID from {databaseOwner}[{objectQualifier}Modules] where ModuleDefID =
(select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where DefinitionName = N'ModuleDefinitionName'))
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment