Skip to content

Instantly share code, notes, and snippets.

@Otterpohl

Otterpohl/Set-AutoShrinkOff

Created May 13, 2022 16:18
Show Gist options
  • Save Otterpohl/dc8ddffa4e5e0cd76523ba014d51824b to your computer and use it in GitHub Desktop.
Save Otterpohl/dc8ddffa4e5e0cd76523ba014d51824b to your computer and use it in GitHub Desktop.
Download ZIP
Set AutoShrink to disabled for all databases where it is enabled
Raw
Set-AutoShrinkOff
SELECT 'ALTER DATABASE ' + QUOTENAME(name) + ' SET AUTO_SHRINK OFF WITH NO_WAIT;' AS [To Execute]
FROM sys.databases
WHERE is_auto_shrink_on = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment