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

422 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

82 reads

Blogs

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Read the latest Blogs

Forums

SQL SSRS license info

By mxy

hello,   i am trying to find where SSRS edition and product key information...

Baseball Everywhere

By Ryan Booz

Comments posted to this topic are about the item Baseball Everywhere

How to run custom python module on SQL Server?

By yyang5823

I am working on a small test script on SQL server 2022 using python...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers