List Extended Database properties for all databases

I am using database properties to add some useful information for each database. Tired of exploring each database from the menu in SSMS to look for specific information, I decided to make a script listing the extended properties for all my databases. I am pleased to offer this to the community 🙂

2019-10-01 (first published: )

684 reads

Blogs

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Solve SQL Server Resource Database Crash

By

Based on Microsoft Documentation <The Resource database is a read-only database that contains all...

Daily Coping 20 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL remove part of String Question

By dhanekulakalyan

Hello All, I have a string something like below("inputstring" column) and i want to...

SCOM Discovery error: Requested registry access is not allowed

By webrunner

Hello experts, I keep seeing this error alert sent from SCOM about some of...

cpu and memory connection in sql server

By sqlguy80

Hello, DBA Gurus, so we have a prod SQL Server VM instance. I noticed...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers