LINKED SERVERS SUMMARY
-- Script to get all the info from the Linked Server properties -- Also extract the ALIAS from the client network utility -- Also extract the DNS IP from the Alias USE master go IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name = 'linkedsvr_detail') DROP TABLE tempdb..linkedsvr_detail IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name = 'linkedsvr_summary') DROP TABLE tempdb..linkedsvr_..