If you use SQL Server 2000's extended property features to document your database tables, this stored procedure can provide an easy way to extract the table and column-level descriptions for reporting purposes. This procedure can easily be modified to provide additional information to suit your needs. The script works only on SQL Server 2000.
Author: Kevin O'Quinn
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
"as -is", without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose...
Back to Database Journal Home