InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 22:03:53 GMT20http://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxHi Charipg, You're welcome! Have a great time!Best Regards,SQLBuddy.Thu, 27 Aug 2009 12:32:12 GMTsqlbuddy123http://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxthanks ..............its selecting everything...........thanks sqlbuddy123..................Thu, 27 Aug 2009 12:23:26 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxthanks sqlbuddy123..........but it is not selecting recoverymodel..............Thu, 27 Aug 2009 12:22:15 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxHi Charipg, Check this! Exec sp_helpdbBest RegardsSQLBuddyThu, 27 Aug 2009 11:54:35 GMTsqlbuddy123http://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxI'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?Thu, 27 Aug 2009 11:40:14 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxQuery sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)Thu, 27 Aug 2009 11:33:16 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic778508-146-1.aspxi need the query(dbname,size,recoverymodel) for all databases in a server.Thu, 27 Aug 2009 11:19:38 GMTcharipg