Schema Search solves a common SQL Server problem: if you’ve ever managed more than a handful of databases on an instance, you’ve probably faced the moment when you need to find a stored procedure with “Customer” in the name but have no idea which of your 30-odd databases it lives in. Or maybe you’re doing a security audit and need to find every object that references a specific table or column — across all databases, all at once. That’s exactly …

Schema Search in Database Health Monitor: Find Anything Across Your Entire SQL Server Instance Read more »