Search all databases for a particular string.
2017-01-30 (first published: 2017-01-26)
Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!
2016-04-15 (first published: 2014-12-01)
globally change all the database owners on a server.
2010-09-08 (first published: 2010-09-02)
Search for GUEST Access Level in all
2008-08-06 (first published: 2008-06-16)