Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT name FROM sys.databases
  2. WHERE
  3. name
  4. not in
  5. ('master','model','msdb','tempdb','ReportServer','ReportServerTempDB','1303VISBOC')
  6. AND
  7. CASE WHEN state_desc = 'ONLINE'
  8. THEN OBJECT_ID(QUOTENAME(name) + '.[dbo].[_LOOK_UP_TABLE]', 'U')
  9. END IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement