Scripting extended properties

I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]

5 (1)

2006-01-05 (first published: )

1,209 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

Evergreen SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Evergreen SQL Server

Do you really know what’s happening with your servers?

By Additional Articles

Comments posted to this topic are about the item Do you really know what’s...

Going from long to wide

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Going from long to wide

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers