Technical Article

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 πŸ™‚

β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜… β˜…

You rated this post out of 5. Change rating

2019-10-01 (first published: )

1,282 reads

Blogs

Using Git Prune–#SQLNewBlogger

By

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Microsoft Purview new data governance features

By

Starting last week is a rollout of the public preview of a new and...

SQL Database Administration: Not For Everyone (But Maybe It’s for You)

By

Let's get one thing straight: database administration isn't the most glamorous tech job out...

Read the latest Blogs

Forums

Do I need a recursive query for this? bill of materials (sort of)

By pietlinden

I am working on a data warehouse project for a bakery. For the most...

Do I need a recursive query for this? bill of materials (sort of)

By pietlinden

I am working on a data warehouse project for a bakery. For the most...

Create Copy of DB in same server.

By terry999

Hi I want to create a copy of a DB on the same server....

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers