sql常用的命令

SELECT NAME, database_id,create_date 创建时间,is_auto_shrink_on 自动收缩,state_desc 状态,recovery_model_desc 恢复模式,is_published 是否发布库,log_reuse_wait_desc日志重用状态 FROM sys.databases

--修改数据库日志模式：Simple,Full,BULK_LOGGED
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE 
--设置自动收缩
ALTER DATABASE [数据库名] SET AUTO_SHRINK ON WITH NO_WAIT

 

SELECT NAME, database_id,create_date 创建时间,is_auto_shrink_on 自动收缩,state_desc 状态,recovery_model_desc 恢复模式,is_published 是否发布库,log_reuse_wait_desc日志重用状态 FROM sys.databases

--修改数据库日志模式：Simple,Full,BULK_LOGGED
ALTER DATABASE [数据库名] SET RECOVERY SIMPLE 
--设置自动收缩
ALTER DATABASE [数据库名] SET AUTO_SHRINK ON WITH NO_WAIT
--收缩日志
DBCC SHRINKFILE (N'DNName_Log' , 1)

--重建索引
USE DNName;
DECLARE @name varchar(100)

DECLARE authors_cursor CURSOR FOR  
Select [name]   from sysobjects where xtype='u' order by id

OPEN authors_cursor

FETCH NEXT FROM authors_cursor  INTO @name

WHILE @@FETCH_STATUS = 0 
BEGIN    

   DBCC DBREINDEX (@name, '', 90)

   FETCH NEXT FROM authors_cursor  
   INTO @name 
END

deallocate authors_cursor