Owner of the DB
select suser_sname(owner_sid) from sys.databases
AutoIncrementof DB
what do you mean by this
Recovery MOdel of aDB
select recovery_model_desc from sys.databases
No.of Maintaince plan
select * from sysmaintplan_plans
No.of SP'S,No.of UDF'S,No.OF Triggers in a DB.
select * from sysobjects where type_desc in('SQL_STORED_PROCEDURE','SQL_TABLE_VALUED_FUNCTION',
'SQL_TRIGGER')
----------
Ashish