Technical Article

Schema View

Here is a simple view that is useful to pull basic data dictionary information out of your DB user tables. The description field is an extended property that I like to use for built in documentation of fields. This only works with 2000, 7 had a slightly different layout for the system tables.

2004-10-27 (first published: )

326 reads

Blogs

Copying large files from SharePoint Online

By

I recently worked on a project where we needed to copy some large files...

How Long has Your SQL Server Been Online

By

This week’s blog post will help you check your SQL Servers up-time. There are...

The less you hear from or about the DBAs the better they are doing their job.

By

Something I’ve been thinking about recently is that DBAs are best when they are...

Read the latest Blogs

Forums

Ordering String_Split()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering String_Split()

Worse Before Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Worse Before Better

Azure SQL Managed Backup for on-prem databases

By database diva

I have a SQL 2017 on-prem database server that the client wants to back...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers