How can I check for stored procedure consistency across multiples servers I've got a stored procedure on 10 distinct servers, how can I check across all servers for stored procedure consistency? 

I'm currently pulling the definition for each server manually, and comparing it in notepad++ compare tool.

It's quite time consuming, and surely I'm not the first one to have this problem.
Kankuru is a great and FREE monitoring tool for SQL Server developed here in France. Aside from its monitoring capabilities, it also has a DB compare tool that is easy and simple to use.

It will not only show you if your stored procedures, tables, indexes, types, etc. exist on two servers, but also what those differences are between those two servers.



Here is another compare screen



It's very easy to use and as mentioned before, won't cost you a dime.

To setup Kankuru


Create an empty database in some SQL Server called Kankuru. The kankuru database just stores configuration information and some history and its very compact. 
Start Kankuru and from the Home Menu select Configuration





Configure kankuru to use the server\instance and database that you just created.




There is documentation, but its in French. Google translate will be able to get you through one way or another.