I'd likely use a trigger here, with good error handling to let the user know the issue.

Unfortunately there are no data-mart products or cloud services. Everyone sells a data warehouse and people are loading them constantly

To be fair ..

I find it intensely frustrating that the "no business value" argument is used so liberally.  Pretty soon you end up with a mountain of "No business...

As somebody who ...

In an office setting I wonder how much the lack of printing is a natural progression and how much has been a push from Office and...

I find that occasionally reading a newspaper or book is like CDs or vinyl albums. An immersive experience in my hands. Nothing digital that disappears when a screen times...

Ah, that's cool. Thanks

I always clean-up as I go, this way I do it when I am working on it knowing that I will not have a chance later on. It is...

Steve, you touched a live wire on this one with me.  In my humble opinion ( and you all know how humble I am ), if you don't do...

I'll admit that I am a culprit.  The dev instance looks like the SQL version of a condemned building.  Even PROD can be cleaned up a bit.

A decent project...

Another good reason to clear out unused code is when you have a column that is used to filter results and you find that it can contain a new...

People like Brent who say "don't clean up old code" apparently don't have much experience with 40-50 year old codebases that are still mission critical for more than 18...

Ah, that's good. I think.

Running that script for me shows no rights for dbo.

Do you have a screenshot? Wondering what you've got here.

I suspect logging in with the DAC might make this possible, but haven't tried. Curious what your system looks like. Can...

Thanks, I think that a lot of DevOps started out as let's be partners, but the automation overshadowed things and too many people don't act as partners with their clients.

Story of Murray's career.

I am getting killed on WRs, no one showing up or hurt. Amazed. I got 60 pts.