Casper101


It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

Not Selected for the PASS Data Community Summit 2024

By

I got this in an email about a week ago from the PASS Data...

A New Word: Addleworth

By

addleworth – adj. unable to settle the question of whether you’re doing okay in...

Data Technology Learning Resources

By

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...

Read the latest Blogs

Forums

Shout Your Successes

By Grant Fritchey

Comments posted to this topic are about the item Shout Your Successes

Insert (x) rows into table with y columns from string

By Budd

First I want to thank anyone who takes a moment to help with this. ...

Linked Server & Forced Encryption

By r5d4

I recently updated our servers to force encryption. Force Encryption = Yes on the...

Visit the forum

Question of the Day

Updating Sensitivity Classifications

I ran this code on a column in my SQL Server 2022 database:

ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Contact',
    RANK = CRITICAL
);
GO
I then realize I've made a mistake and run this:
ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Contact',
    RANK = HIGH
);
GO
What happens?

See possible answers