The parameter will default to '%' meaning all user databases are in scope if a database is not specified. The procedures uses a VARCHAR (max) parameter (@TSQLExec) in order to execute the T-SQL shrink ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.

solution involves creating a T-SQL stored procedure in a SQL Server database called dbo.usp_ShrinkAllLogsExcludeSysDBS that will get a parameter for the database name. The parameter will default to '% ...