Getting Basic Information of ALL Databases using system stored proc(sp_helpdb)

sp_helpdb -- Helps to get basic information of all database in the server . Information like name,db_size,created,status etc


Usage:

exec sp_helpdb 


Status Column have the following information:

Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAnsiNullsEnabled, IsAnsiPaddingEnabled, IsAnsiWarningsEnabled, IsArithmeticAbortEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled, IsNullConcat, IsQuotedIdentifiersEnabled

Thanks for reading this blog :)
Ebook Download
View all
Learn
View all