Remove Auto Shrink from all databases

Use below query to remove Auto Shrink from all database: 


DECLARE @DatabaseName varchar(100)  
DECLARE @AlterQuery varchar(500)  
  
DECLARE @CurDB CURSOR READ_ONLY FOR  
SELECT name FROM sys.databases WHERE database_id >  4 AND DATABASEPROPERTYEX(name, 'IsAutoShrink') = 1  
  
OPEN @CurDB  
FETCH NEXT FROM @CurDB INTO @DatabaseName  
WHILE @@FETCH_STATUS = 0  
    BEGIN  
    SET @AlterQuery ='ALTER DATABASE [' + @DatabaseName + '] SET AUTO_SHRINK OFF WITH NO_WAIT' + CHAR(10)  
    print @AlterQuery  
    EXEC(@AlterQuery)  
    FETCH NEXT FROM @CurDB INTO @DatabaseName  
    END  
  
CLOSE @CurDB  
DEALLOCATE @CurDB  

Remove Auto Shrink from all databases

DECLARE @databasename varchar(100)  
DECLARE @sqlAlterStatement varchar(500)  
  
DECLARE NastyCursorThing CURSOR READ_ONLY FOR  
SELECT name FROM sys.databases  
WHERE database_id >  4 AND DATABASEPROPERTYEX(name, 'IsAutoShrink') = 1  
  
OPEN NastyCursorThing  
FETCH NEXT FROM NastyCursorThing INTO @databasename  
WHILE @@FETCH_STATUS = 0  
    BEGIN  
    SET @sqlAlterStatement ='ALTER DATABASE [' + @databasename + '] SET AUTO_SHRINK OFF WITH NO_WAIT' + CHAR(10)  
    print @sqlAlterStatement  
    EXEC(@sqlAlterStatement)  
    FETCH NEXT FROM NastyCursorThing INTO @databasename  
    END  
  
CLOSE NastyCursorThing  
DEALLOCATE NastyCursorThing