So I was flipping the DBs on one of my QA servers from FULL to SIMPLE recovery (we don't need PiT recovery in QA) and got thinking...
Yes, that explains the fire trucks you heard go by a few minutes ago smart guy...
Is it possible to write and ALTER statement something like this:
ALTER DATABASE (SELECT NAME FROM sys.databases
WHERE recovery_model_desc = N'SIMPLE'
AND name NOT IN ('master','model','msdb','tempdb'))
SET RECOVERY SIMPLE WITH NO_WAIT;
Yes, I know this could be a potentially dangerous trick (just replace 'set recovery' with 'set offline' for some *real* fun) but when you've got a bunch of DBs to switch, it's quicker than copy/paste, and easier to key up then using sp_msforeachdb (which as someone pointed out on SQLSkills I believe, doesn't always work right)
Regardless, I've already done the copy-paste method, but for future reference...