I like this. It’s succinct
EXEC sp_MSforeachdb 'use [?] if db_id() > 4
SELECT db_name() [database], * FROM sys.triggers
WHERE is_disabled = 1';
-
Follow
Following
Already have a WordPress.com account? Log in now.
I like this. It’s succinct
EXEC sp_MSforeachdb 'use [?] if db_id() > 4
SELECT db_name() [database], * FROM sys.triggers
WHERE is_disabled = 1';
Database Consultant 