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,223 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Identity Insert

By erics44

hopefully a quick one This tsql SET IDENTITY_INSERT dbo.tblSCVMatchedv3 ON insert into dbo.tblSCVMatchedv3 select...

SET STATISTICS equivalent

By DamianC

Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers