2011年12月27日
重置索引初始值
摘要： USE ＸＸＸＸ GO DBCC CHECKIDENT (jobs, RESEED, 30) GO 阅读全文
posted @ 2011-12-27 11:12 CalvinChu 阅读(343) 评论(0) 推荐(0) 编辑
清ＭＳＳＱＬ日志
摘要： USE [master] GO ALTER DATABASE ASPState SET RECOVERY SIMPLE WITH NO_WAITGO ALTER DATABASE ASPState SET RECOVERY SIMPLE GO USE ASPStateGO DBCC SHRINKFILE (N'ASPState_log' , 11, TRUNCATEONLY)GO USE [master] GO ALTER DATABASE ASPState SET RECOVERY FULL WITH NO_WAITGO ALTER DATABASE ASPState SET 阅读全文
posted @ 2011-12-27 11:09 CalvinChu 阅读(155) 评论(0) 推荐(0) 编辑