I have an interesting question on this topic and its probably worth testing sometime. What happens if that deleted login owned a SQL Agent Job? SQL Jobs run with the...

Well... that was a scary read, but thank you. Why would MS even make it possible to query the password hashes!? It should be an internal process completely hidden away....

Nice article. I'm still working on writing my first technical article. It's a bit of a daunting task, but I'm getting there.

Regarding sp_ExecuteSQL: Dynamic SQL is one of those things...