Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_MSforeachdb 'IF UPPER(''?'') NOT IN (''TEMPDB'',''MODEL'',''MSDB'', ''MASTER'')
- BEGIN
- IF DATABASEPROPERTYEX(''?'', ''Recovery'') = ''FULL''
- BEGIN
- USE ?
- SELECT DB_NAME() AS [Current Database];
- END
- END'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement