|
Posted by David Portas on 10/31/41 11:29
"rcamarda" <rcamarda@cablespeed.com> wrote in message
news:1129328233.934256.231310@g49g2000cwa.googlegroups.com...
> Better Question. How can it tell the databases in my sql instance that
> have a recovery model of 'Simple'?
> Hope this makes sense now
> Thanks
>
SELECT catalog_name
FROM information_schema.schemata
WHERE DATABASEPROPERTYEX(catalog_name,'RECOVERY') = 'SIMPLE' ;
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|