You can run the result as a csv file or just press F5 for the result set.
2009-04-28
2,356 reads
You can run the result as a csv file or just press F5 for the result set.
set nocount on declare @dblist varchar(20) declare cur cursor for select name from sys.databases open cur fetch next from cur into @dblist while @@fetch_status = 0 begin exec sp_helpdb @dblist fetch next from cur into @dblist end close cur deallocate cur