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

5 (1)

2006-01-05 (first published: )

1,227 reads

Blogs

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Read the latest Blogs

Forums

Problem Importing NULLs in varchar field

By John524

hello, This is something I'm really struggling with and haven't found much when I...

SQL Server 2022 is RTM

By Grant Fritchey

You can get your hands on SQL Server 2022 right now and this forum,...

Blocking

By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers