1
0
mirror of https://github.com/alex-bochkov/ssms-addin.git synced 2025-11-23 22:04:53 +02:00
Files
ssms-addin/QueryTemplates/Common Scripts/shrink-all-log-files.sql
2019-01-18 14:05:01 -08:00

11 lines
220 B
Transact-SQL

/* this is terrible idea, don't do it */
SELECT 'USE [' + DB_NAME(database_id) + ']
GO
DBCC SHRINKFILE (N''' + name + ''' , 0, TRUNCATEONLY)
GO
'
FROM sys.master_files
WHERE type_desc = 'LOG'
AND database_id > 4;