USE msdb
EXEC sp_help backupset
(displays help info about the backupset table in ~8 recordsets)
Is it possible to have Toad display multiple returned recordsets in a single tab. In SSMS execution of multiple SELECT statements will display recordsets “stacked” in a single window (with separate headers and optional scrollbar if needed). I am missing a similar option in Toad - I have a lot of small utility scripts giving various information back in 2 to 5 small but distinct recordsets. I am missing the possibility to see the content of them in one screen.
Sample script: