Try this out https://social.msdn.microsoft.com/Forums/en-US/9a23a5ec-f79b-4c18-b4f6-e52b54de71eb/how-to-compare-sql-server-stored-procedures-from-two-separate-databases?forum=sqldatabaseengine