Expected output

• shiv-356842

  SSCarpal Tunnel

  Points: 4309

  More actions

  February 1, 2011 at 3:34 am

  #230935

  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.

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  February 1, 2011 at 4:08 am

  #1280834

  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