Script to enumerate Recovery mode

Hello,
YOu could also use:-
sp_helpdb
THanks
Hari
"MV" <MV@.MV.MV> wrote in message
news:uKu5FP7PHHA.4824@.TK2MSFTNGP02.phx.gbl...
> Hi, I search a script that report me a list of all my several DB on my SQL
> Servers, with which Recovery model they have (simple,full or bulked). Did
> somebody have something? Thanks
>
I you need precise information like only recoverymodel then use Uri's query
statement if you need complete details Hari's SP_HELPDB will be useful.
"Hari Prasad" wrote:

> Hello,
> YOu could also use:-
> sp_helpdb
> THanks
> Hari
> "MV" <MV@.MV.MV> wrote in message
> news:uKu5FP7PHHA.4824@.TK2MSFTNGP02.phx.gbl...
>
>