*sigh* ANOTHER misleading title. This is NOT how to import a ragged-right file. It's how to remove unwanted header & trailer records from a perfectly formed NON-ragged-right file. I was...

I think you'll find that

SELECT

CAST('2007-10-01' AS DATETIME) + Number-1

FROM dbo.GetNumbers(1, 30)

assumes a 30-day month, and misses 2007-10-31

Once again, the question poser asks one question ("which protocols are enabled") and gives a wrong answer, by using a definitive statement that answers a DIFFERENT issue (about "Network Protocols")....

Ok, so CLR isn't a PURE DML trigger. But it CAN be a DML trigger.

I've checked and rechecked, and the word 'pure' doesn't occur in the question.

It's a...