Database properties

Last Post 01 Jul 2008 09:26 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Jul 2008 07:55 AM
SQL Server unusual behavior

i have this select
select top 100 percent 'testbux' as ServerName
, [name] as DatabaseName
, cast(databasepropertyex([name], 'Recovery') as varchar(12)) as RecoveryModel
from testbux.master.dbo.sysdatabases
where [name] not in ('master', 'model', 'msdb', 'tempdb', 'distribution', 'pubs', 'northwind')
order by ServerName, DatabaseName

recoverymodel returns null for some databases

when i go to these db properties in EM i can see some are simple and some are in Full recovery mode but in either case OK button is greyed out, i can chane the option but i cant OK it

I used alter statement to change option, change takes place but still OK is greyed out

Has anyone seen anything similar?

New Member
New Member

01 Jul 2008 09:26 AM
server admim all over

Acceptable Use Policy