SQL query to shrink all log files on sql instance April 19, 2018 USE masterexec sp_MSforeachdb 'use [?] print ''?'' print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200)) if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE '' dbcc shrinkfile(2,1)' Share Get link Facebook X Pinterest Email Other Apps Share Get link Facebook X Pinterest Email Other Apps Comments
Comments
Post a Comment