how find out if db is readonly or dbo use only with sql

[alex]

Hi,

I have sciprt that assign object
permissions to all databases.

I want to exclude all read only and dbo use only databases

Thank you

Alex

[rmiao]

Run 'sp_dboption db_name'.

[MAK]

select Status=
CASE Status&1024 WHEN 1024 THEN 'Read Only ' +char(13)+char(10) ELSE '' END+
CASE Status&2048 WHEN 2048 THEN ' DBO Use only ' +char(13)+char(10) ELSE '' END
from sysdatabases

[alex]

thank a lot for both solutions

but what is Status&1024 ?


Alex

[rmiao]

It performs a bitwise logical AND operation between two integer values.

[alex]

one more question

I have maintenance plan to reorganize all db , any way to make it run for all db except read only

thank you

[MAK]

I am afraid you have to select databases manually