We want to analyze database ,to find specific list of columns of some tables, which are not used in any of the Stored Procedure present in that database.
Basically this database is secondary Databases which is used to perform only specific functionality,so Only Sp related to those SPs are placed in this DB but here we have all tables with all columns..
Now i want to identify and remove unused columns...
Can some one please suggest on this.can we achieve this via some DMV ?
Thanks in advance.