DECLARE @intDBID INTEGER
DECLARE intDBID CURSOR FOR SELECT database_id from sys.databases AS intDBID where owner_sid<>1
OPEN intDBID
WHILE 1=1 BEGIN
FETCH FROM intDBID INTO @intDBID
/*Так, на мой взгляд, удобнее обходиться с курсорами*/
IF @@fetch_status=-1
BREAK
IF @@fetch_status=-2
CONTINUE
DBCC FLUSHPROCINDB (@intDBID)
END
DEALLOCATE intDBID
