How to display the database property

• tamir-859073

  SSC Veteran

  Points: 233

  More actions

  March 29, 2011 at 3:16 am

  #236867

  What command displays the list of databases with the properties

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  March 29, 2011 at 3:20 am

  #1304728

  select * from sys.databases

  ]

• Ysaias Portes-QUI Group

  SSCrazy

  Points: 2127

  More actions

  April 11, 2011 at 11:37 am

  #1309991

  You should use the sp_helpdb Stored Procedure

  you can pass parameters if you want a specific databases.

  i.e. sp_helpdb 'master'

  QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

• Lowell

  SSC Guru

  Points: 323524

  More actions

  April 11, 2011 at 11:47 am

  #1309997

  and yet another option:

  SELECT

  DATABASEPROPERTYEX(db_name(),'Collation') AS Collation,

  DATABASEPROPERTYEX(db_name(),'ComparisonStyle') AS ComparisonStyle,

  DATABASEPROPERTYEX(db_name(),'IsAnsiNullDefault') AS IsAnsiNullDefault,

  DATABASEPROPERTYEX(db_name(),'IsAnsiNullsEnabled') AS IsAnsiNullsEnabled,

  DATABASEPROPERTYEX(db_name(),'IsAnsiPaddingEnabled') AS IsAnsiPaddingEnabled,

  DATABASEPROPERTYEX(db_name(),'IsAnsiWarningsEnabled') AS IsAnsiWarningsEnabled,

  DATABASEPROPERTYEX(db_name(),'IsArithmeticAbortEnabled') AS IsArithmeticAbortEnabled,

  DATABASEPROPERTYEX(db_name(),'IsAutoClose') AS IsAutoClose,

  DATABASEPROPERTYEX(db_name(),'IsAutoCreateStatistics') AS IsAutoCreateStatistics,

  DATABASEPROPERTYEX(db_name(),'IsAutoShrink') AS IsAutoShrink,

  DATABASEPROPERTYEX(db_name(),'IsAutoUpdateStatistics') AS IsAutoUpdateStatistics,

  DATABASEPROPERTYEX(db_name(),'IsCloseCursorsOnCommitEnabled') AS IsCloseCursorsOnCommitEnabled,

  DATABASEPROPERTYEX(db_name(),'IsFulltextEnabled') AS IsFulltextEnabled,

  DATABASEPROPERTYEX(db_name(),'IsInStandBy') AS IsInStandBy,

  DATABASEPROPERTYEX(db_name(),'IsLocalCursorsDefault') AS IsLocalCursorsDefault,

  DATABASEPROPERTYEX(db_name(),'IsMergePublished') AS IsMergePublished,

  DATABASEPROPERTYEX(db_name(),'IsNullConcat') AS IsNullConcat,

  DATABASEPROPERTYEX(db_name(),'IsNumericRoundAbortEnabled') AS IsNumericRoundAbortEnabled,

  DATABASEPROPERTYEX(db_name(),'IsParameterizationForced') AS IsParameterizationForced,

  DATABASEPROPERTYEX(db_name(),'IsQuotedIdentifiersEnabled') AS IsQuotedIdentifiersEnabled,

  DATABASEPROPERTYEX(db_name(),'IsPublished') AS IsPublished,

  DATABASEPROPERTYEX(db_name(),'IsRecursiveTriggersEnabled') AS IsRecursiveTriggersEnabled,

  DATABASEPROPERTYEX(db_name(),'IsSubscribed') AS IsSubscribed,

  DATABASEPROPERTYEX(db_name(),'IsSyncWithBackup') AS IsSyncWithBackup,

  DATABASEPROPERTYEX(db_name(),'IsTornPageDetectionEnabled') AS IsTornPageDetectionEnabled,

  DATABASEPROPERTYEX(db_name(),'LCID') AS LCID,

  DATABASEPROPERTYEX(db_name(),'Recovery') AS Recovery,

  DATABASEPROPERTYEX(db_name(),'SQLSortOrder') AS SQLSortOrder,

  DATABASEPROPERTYEX(db_name(),'Status') AS Status,

  DATABASEPROPERTYEX(db_name(),'Updateability') AS Updateability,

  DATABASEPROPERTYEX(db_name(),'UserAccess ') AS UserAccess ,

  DATABASEPROPERTYEX(db_name(),'Version') AS Version

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!