摘要:
MessageExecuted as user: CN\HKSQLPWV625sqlagent. Cannot shrink log file 2 (DIX_Log) because the logical log file located at the end of the file is in 阅读全文
posted @ 2017-01-20 15:00
Lucy Yang
阅读(829)评论(0)推荐(0)
摘要:
当前月: USE [DBName] Go Use Database, Declare Variables DECLARE @ReportGenerationDate DATE DECLARE @ReportMonth INT DECLARE @ReportMonthStart DATE DECLAR 阅读全文
posted @ 2017-01-05 17:01
Lucy Yang
阅读(137)评论(0)推荐(0)
摘要:
declare @databasename nvarchar(100)--定义游标以及赋值 获取所有Online的Database Namedeclare getDataBaseCursor cursor for select name from master.sys.databases where... 阅读全文
posted @ 2015-09-10 11:00
Lucy Yang
阅读(235)评论(0)推荐(0)