Another data dictionary
Pulls relevant information including col. names, keys, and the description (if the description field is filled out).This makes a good source for a data dictionary report.
2005-08-17 (first published: 2005-08-12)
480 reads
Database data dictionary
This script returns a description of the database with references to all tables in the database with keys listed. If the column description has been filled out the listing includes that text.If you want to get a report on the structure of each database, just add this script to each database, and then use a […]
2003-08-14
808 reads
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Third party backup softwares
Hi Team, Can you someone suggest a few good third part backup tools, with...
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers