query(dbname,size,recoverymodel)

  • i need the query(dbname,size,recoverymodel) for all databases in a server.

  • Query sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I'm just curious, but have you even tried looking some of this stuff up in BOL (Books Online, the SQL Server Help System) that you can easily access from SSMS (SQL Server Management Studio) by simply pressing the {f1} function key?

  • Hi Charipg,

    Check this!

    Exec sp_helpdb

    Best Regards

    SQLBuddy

  • thanks sqlbuddy123..........

    but it is not selecting recoverymodel..............

  • thanks ..............its selecting everything...........

    thanks sqlbuddy123..................

  • Hi Charipg,

    You're welcome!

    Have a great time!

    Best Regards,

    SQLBuddy.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply