Reg:Auto Shrink Database [modified]

[P T R K]

Hi Friends, I was running following command in SQL Server 2005.But,it was not worked. The command is, "ALTER DATABASE [mydatabase name] SET AUTO_SHRINK ON WITH NO_WAIT;" Is this correct , i was using in sql server? Please suggest me. The following syntax using for auto shrink database log. ALTER DATABASE database SET optionspec [ ,...n ] [ WITH termination ] [;] optionspec: AUTO_SHRINK {ON | OFF} Termination: ROLLBACK AFTER integer [SECONDS] ROLLBACK IMMEDIATE NO_WAIT My problem is, i have shrink my database transaction log every time by manually. So, i was using above auto shrink command. Thanks in advance, Rameshkumar Thirumalaisamy

modified on Thursday, January 31, 2008 7:31:20 AM