marcusrehm

declare @dbname varchar(255);
DECLARE dbname_cursor CURSOR FOR 
	SELECT name--, database_id, create_date, STATE_DESC
	FROM sys.databases
	WHERE STATE_DESC in ('SINGLE_USER', 'SUSPECT', 'RECOVERY_PENDING');

OPEN dbname_cursor
FETCH NEXT FROM dbname_cursor
INTO @dbname