Cerca opzioni database su un server

-- This script works well in SQL 2000, didn't test in 2005+) 

DECLARE @DataBase sysname 

DECLARE	database_cursor CURSOR FOR 
SELECT	quotename(name) as Base 
FROM 	master..sysdatabases 
WHERE	DATABASEPROPERTYEX(name, 'Status') = 'ONLINE' AND 
		DATABASEPROPERTYEX(name, 'IsAutoShrink') = 1 

OPEN database_cursor 

FETCH NEXT 
FROM database_cursor 
INTO @DataBase 

WHILE @@FETCH_STATUS = 0 
	BEGIN 
		PRINT @DataBase
--		EXEC ('ALTER DATABASE ' + @DataBase + ' SET AUTO_SHRINK OFF') 

		FETCH NEXT 
		FROM database_cursor 
		INTO @DataBase 
	END 

CLOSE database_cursor 
DEALLOCATE database_cursor 
GO