SQL Server, Shrink Database Maintenance Task Failing

[Adam_H_3.14]

Hello.I am experiencing problems with my script at the second to last line: Exec (@SQL4). I would very much appreciate help and assistance to get this running. Thank you so much. DECLARE @db1 varchar(20)Declare @SQL1 VarChar(500)Declare @SQL2 VarChar(1000)Declare @SQL3 VarChar(500)Declare @SQL4 VarChar(500)...Declare @SQL3 VarChar(500)SELECT @SQL3 = 'USE ' + @db1Exec (@SQL3)GoDeclare @SQL4 VarChar(500)SELECT @SQL4 = 'DBCC SHRINKDATABASE(' + @db1 + ', 5, TRUNCATEONLY)'Exec (@SQL4)GO

Continue reading...