The situation I have is that I have a stored proc, let's say called up_DoSomething. Due to a lack of rigour in the config management department, there are several versions of this SP, let's say called
up_DoSomething_2012, up_DoSomething_Interim, etc, etc.
What I need to do is to compare any of the procs with any other - also I am on SQL Compare 9. Can this be done? (please say yes.)