Yes I'm being picky but doesn't this belong in Scripts rather than articles?
Terry
I can't agree more, there's no way that those 2 words should ever appear in the same sentence
Oh, wait, how about...
"it's no good, he's used a cursor rather than doing it properly with set based logic"
or
"good, said the highly paid consultant, i see that they've used a cursor; i should be able to make things a little faster if you want to pay me some more money"
(but only for 99.99999 % of cases)
This likely won't make any difference when looping through stored procedure names, but it should be noted that "_" is a wildcard, representing any one character.
like 'dt_%' would be better written as like 'dt\_%' escape '\' to force the script to treat the underscore as itself.
Otherwise, great script! Very useful.
I'd vote for creating the "executors" role, adding "execute" permission on all the SPs to that and then adding the user(s) in question to the "executors" role.
Maybe "executors" would be a good addition to the model db.
By the way, where's your defensive "is this a real login" check? Chalk it up to paranoia, if you like, but I'd have a test in there.
