dmeissner - Saturday, August 12, 2017 7:07 PM
If the op had phrased the question in such a fashion, perhaps there wouldn't have been what you call a lame dialog of ideas. As it was, the OP asked a general question either open to interpretation with an urge to get at the underlying reason for the open question or open to very short, unhelpful answers like "Submit a CONNECT item".
So, do you have an answer to the OPs question or was it your intent to actually succeed in posting something even more lame than what you've cited (and you DID succeed in grand style at that)?
To answer the OPs questions, although subroutines don't exist in SQL Server, there are a whole lot of alternatives and a good number of them don't require them to exist in any of the databases that you want to affect. But it depends on what you want to do and the OP didn't cite that purpose in the original post and so a discussion ensued. As for compelling MS to do anything, log into the MS CONNECT site, make a suggestion, and try to get people to vote it up. If MS thinks it's a lame suggestion or doesn't see the merit in doing it, they'll close the item regardless of the vote. If they don't know what to do with it, they may close it or keep it open for a decade. If they think it's a good idea, they may work on it now or in a decade and eventually put it in place sometimes with or without trickle down to previous versions.
As for your specific question as to how to check for existence of objects and possibly create or affect objections in 100 or 500 databases (whatever) on the same server, you could use the undocumented sp_MSForEachDB or roll your own little bit of dynamic sql or learn how to use temporary stored procedures with dynamic sql. All you have to do is ask a reasonable question, which includes why you want to do it so we can help you with the best of many possible solutions, or make a clarification without being a freakin' troll about it. Comprende?
Now, take the chip off your shoulder and welcome aboard! 😉
--Jeff Moden
Change is inevitable... Change for the better is not.