Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name FROM sys.databases
- WHERE
- name
- not in
- ('master','model','msdb','tempdb','ReportServer','ReportServerTempDB','1303VISBOC')
- AND
- CASE WHEN state_desc = 'ONLINE'
- THEN OBJECT_ID(QUOTENAME(name) + '.[dbo].[_LOOK_UP_TABLE]', 'U')
- END IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement