Technical Article

Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

You rated this post out of 5. Change rating

2007-07-04

421 reads

Technical Article

Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

You rated this post out of 5. Change rating

2007-07-04

79 reads

Blogs

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023

By

I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs

Forums

Baking up and restores VLDBs

By ericwenger1

Some of our databases are getting be close to 2 terabytes. We are backing...

Data Analysis with Python: Calculating Mean and Median

By Piyushbhatt

I'm working on a data analysis project in Python and need to calculate both...

Database recovery

By sharathgt

Hi, My .mdf file is accidentally deleted at client's place and without bothering the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers