All authors

Technical Article

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, […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2006-01-05 (first published: )

1,239 reads

All authors

Blogs

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

By

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Read the latest Blogs

Forums

Trying a new post to see what happens

By Steve Jones - SSC Editor

is this visible? select @@version

How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?

By Dr. Medha Sharma

Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

By Site Owners

Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...

Visit the forum

Question of the Day

The New Database CheckDB

I run this code: 

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned?

See possible answers