Advertisement
Guest User

Untitled

a guest
Aug 19th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. EXEC sp_MSforeachdb 'IF UPPER(''?'') NOT IN (''TEMPDB'',''MODEL'',''MSDB'', ''MASTER'')
  2. BEGIN
  3. IF DATABASEPROPERTYEX(''?'', ''Recovery'') = ''FULL''
  4. BEGIN
  5. USE ?
  6. SELECT DB_NAME() AS [Current Database];
  7. END
  8. END'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement