extended properties

List Extended Database properties for all databases

  • Script

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: )

553 reads

Scripting the Description of Database Tables Using Extended Properties

  • Article

Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.

2018-03-23

3,324 reads

Blogs

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code β€˜Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Read the latest Blogs

Forums

Read Only Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Read Only Files

Why A Query May be Faster the Second Time it Runs

By Kendra Little

Comments posted to this topic are about the item Why A Query May be...

OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans

By sg_twinmaple

Hi, I'm getting a connection error when I try to run even the most...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers