Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]


3,095 reads


GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)


This blog post is about the situation where after upgrading to the latest macOS...

Improving TweetDeck with Better TweetDeck


If you are at involved with the #sqlfamily, you are bound to hear about...

Interview with Bob Ward


This is the eight interview we have done. This time our guest is the...

Read the latest Blogs


Need help on ssrs report parameters or expression

By Dee Dee-422077

Hi, I have created an SSRS report that renders a table from my DB....

Cannot UtilizeConnection via SSH from MS Sql Server to Postgresql DB (SSMS, SSIS

By cboone

I have an SSIS project that I am trying to deploy. When I run...

Help to optimize select query

By U J

Need help to rewrite the query for faster result. use ABC_DB; SELECT c.otherID, a.shortname,...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers