摘要： SELECT [JobName] = [jobs].[name] ,[JobOwner] = SUSER_SNAME(jobs.owner_sid) ,[Enabled] = CASE [jobs].[enabled] WHEN 1 THEN 'Yes' ELSE 'No' END ,[Schedu 阅读全文

摘要： SELECT 'USE [' + db.name + '] ALTER DATABASE [' + db.name + '] SET RECOVERY SIMPLE DBCC SHRINKFILE (''' + mf.name + ''', 1) ALTER DATABASE [' + db.nam 阅读全文