Report table and column-level extended properties

SQL Server 2000's extended properties provide an easy way to store your data dictionary documentation within the database itself. This stored proc provides an easy way to extract all the table and column-level descriptions from those system tables for reporting purposes. This procedure can easily be modified to provide additional information to suite your needs. […]

2002-04-22

205 reads

Blogs

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

Read the latest Blogs

Forums

Developer Edition

By Admingod

I am proposing to the business that we use SQL 2019 Developer in our...

SQL server agent stop working (the server threw an exception [0x80010105])

By TecMath

Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...

change data capture errors cdc_errors

By jaya

The cdc capture job ran into errors on our prod server. The error reporting...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers