>>Hi,
>>
>>Does SSMS have a feature where two stored procedures (in the same database, under different names) or in two different databases (with the same name) can be compared? In order to view the differences?
>>
>>TIA
>
>Hey, Dmitry,
>
>I use an application called WinMerge for this. It allows comparison of files of almost any type. I script each proc into a file then load them in WinMerge and let it show me the differences (if any).
>A free version of WinMerge should be available on the Web.
>
>Bill
I also use WinMerge. Very powerful. I add
FoxBin2Prg by Fernando D. Bozzo. It allows you to convert SCX, VCX, FRX, etc. to text form where you can use WinMerge.
For WinMerge, nice features: Alt+Up/Down navigate difference to difference. And you can use Alt+Right/Left to copy code from one text file to the other. After updating, you can use FoxBin2Prg to put it back into SCX, VCX, FRX, etc. form. A really awesome combo for version comparison, or visualizing change history.