ALTER DATABASE ERPDB   SET RECOVERY SIMPLE;--设置简单恢复模式   GO   DBCC SHRINKFILE (ERPDB_Log, 1);   GO   ALTER DATABASE ERPDB   SET RECOVERY FULL;--恢复为原模式   GO

USE [CommonOA] GO /****** Object:  StoredProcedure [dbo].[P_viewPage]    Script Date: 07/31/2013 17:08:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[P_viewPage]