Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Expected output Expand / Collapse
Author
Message
Posted Tuesday, February 1, 2011 3:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:36 AM
Points: 241, Visits: 1,196
Hi Team,

I need below output

Owner of the DB,AutoIncrementof DB,Recovery MOdel of aDB, No.of Maintaince plan,No.of SP'S,No.of UDF'S,No.OF Triggers in a DB.

can any body plz help me.
Post #1056687
Posted Tuesday, February 1, 2011 4:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 3:10 AM
Points: 880, Visits: 4,092


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
Post #1056710
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse