query(dbname,size,recoverymodel)

Question

query(dbname,size,recoverymodel)

charipg

SSCrazy Eights

Points: 9888
More actions
August 27, 2009 at 11:19 am

#133268

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

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

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?

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

Hi Charipg,

Check this!

Exec sp_helpdb

Best Regards

SQLBuddy

charipg SSCrazy Eights Points: 9888 More actions · Answer 4

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

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

charipg SSCrazy Eights Points: 9888 More actions · Answer 5

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

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Hi Charipg,

You're welcome!

Have a great time!

Best Regards,

SQLBuddy.