hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...

right-click an object in SSMS and click an option called something like 'compare against other environment'.

it would then bring up a message box where you could browse an object-explorer for the corresponding object.

the use cases I see all the time for this are

1. when people have stored procs next to each other called

spSomeProc
spSomeProcv2
spSomeProcnew
spSomeProc.old

etc on the same database.

2 when you are troubleshooting and you want to double check the same object across environments. i.e.

Server1.Master.spSomeProc
Server2.Master.spSomeProc

at the moment (because we don't have source control) I have to script the objects to file and then use k-diff or winmerge. redgate sql compare seems to more appropriate for comparing whole databases and sometimes you want to focus in on one or two objects

hope that makes sense
cheers
Ben.