March 10, 2014

Subscribe

Find objects using linked servers via powershell

by Scott Newman

This script just executes a query on a per-database level to find objects via their definitions in the sys.all_sql_modules table that reference a linked server defined on the current server. Right now it just spits the results out to a gridview. Minimally tested, use at your own risk.