I spent 20 minutes the other night thinking about possible ways to remove an
ntextcolumn from a 28TB table, and I did all of this thinking for nothing.
I was investigating the table for other reasons. And because I’m lazy, I scanned the output of the system procedure
sys.sp_columns(instead of writing a proper query against more modern metadata). I spotted the legacy type in the output, and dropped everything.
I’m pretty sure I’ve never seen
sp_columns before. For everyone in the same boat, continue dutifully avoiding it.