SQL Server video to find objects that reference invalid objects
By: Tim Smith | Comments (3) | Related: More > Stored Procedures
Problem / Solution
One of the tasks of DBAs is to maintain the database and correct or remove any objects that reference invalid objects. If you have a database with lots of objects, it can be very time consuming to check each object for invalid references. In this video tip we will look at using PowerShell along with sys.sp_refreshsqlmodule to help you identify which objects may be referencing invalid objects.
Key Learning Items
- Using PowerShell to loop through servers, databases and database objects
- Using sys.sp_refreshsqlmodule
