#TodayILearned that to programatically find which #SqlServer databases are in standby mode, you can do this:

select name, DATABASEPROPERTYEX(name, ‘Isinstandby’) from sysdatabases