Hugh,

That's got it -

You beauty!!! - thanks very much.

Matthew

-----Original Message-----
From: Hugh du Toit
[mailto:mssqldba-ezmlmshield-x37481901.[Email address protected]
Sent: 31 March 2005 11:46
To: LazyDBA Discussion
Subject: RE: Recovery Mode Flag In System Tables ?



Use dbName
Go
select DATABASEPROPERTYEX( 'dbName' , 'recovery' )

-----Original Message-----
From: Bainton Matthew [mailto:mssqldba-ezmlmshield-x15437807.[Email address protected]
Sent: Thursday, March 31, 2005 12:26 PM
To: LazyDBA Discussion
Subject: Recovery Mode Flag In System Tables ?

All,

Does anyone know where I can find the database recovery mode flag within the system tables? I have a little maintenance script that could really do with identifying the recovery mode of user databases.

Many thanks,

Matthew

www.rspb.org.uk

...


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


...

...

MS Sql Server LazyDBA home page