"rcamarda" <rc******@cablespeed.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I need a sql statment to return a list of tables for a given database
where the Recovery Model option is Simple.
TIA
Rob
The recovery model is a database-wide setting. There is no recovery model
option for individual tables.
You can determine the recovery model like this:
SELECT DATABASEPROPERTYEX('database_name', 'RECOVERY')
--
David Portas
SQL Server MVP
--