Finding strings in a project
-
I have a database with hundreds of stored procedures and I am sure that many of them are never called. I know how to find dependencies within the database using the system tables but that doesn't tell me how many are called from the Visual Studio project (and if so where) I am mulling 2 different approaches but am not really sure how to go about either... 1) FXCop somehow manages to find all the strings in a compiled assembly and tell you where abouts in the project they are. I guess this solution would be optimal as I guess it would exclude comments and such like which may slightly mess up the results. I also guess writing something like that would be pretty time consuming so would be grateful if anyone has any sample code or links to articles doing this sort of thing. 2) I also considered trying to programatically automate the Visual Studio "Find" option and found it very straightforward to get the results to appear in the FindResults Window but no obvious way to get the results into a variable to manipulate. All ideas welcome on either approach (or if you know if something like this already exists please let me know also!)