|
Posted by David Portas on 10/14/05 22:34
"rcamarda" <rcamarda@cablespeed.com> wrote in message
news:1129311952.833612.171530@g14g2000cwa.googlegroups.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
--
Navigation:
[Reply to this message]
|