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

query(dbname,size,recoverymodel) Expand / Collapse
Author
Message
Posted Thursday, August 27, 2009 11:19 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
i need the query(dbname,size,recoverymodel) for all databases in a server.
Post #778508
Posted Thursday, August 27, 2009 11:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 42,829, Visits: 35,959
Query sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #778533
Posted Thursday, August 27, 2009 11:40 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
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?




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #778546
Posted Thursday, August 27, 2009 11:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:14 PM
Points: 1,194, Visits: 2,217
Hi Charipg,

Check this!

Exec sp_helpdb

Best Regards
SQLBuddy
Post #778557
Posted Thursday, August 27, 2009 12:22 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
thanks sqlbuddy123..........

but it is not selecting recoverymodel..............
Post #778582
Posted Thursday, August 27, 2009 12:23 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:21 AM
Points: 412, Visits: 1,020
thanks ..............its selecting everything...........

thanks sqlbuddy123..................
Post #778584
Posted Thursday, August 27, 2009 12:32 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:14 PM
Points: 1,194, Visits: 2,217
Hi Charipg,

You're welcome!

Have a great time!

Best Regards,
SQLBuddy.
Post #778591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse