select a.name,
OBJECT_DEFINITION(a.object_id) as one,
OBJECT_DEFINITION(b.object_id) as two
from NSW_finaldata.sys.procedures a, NSW_clientdata.sys.procedures b
where a.name=b.name
AND OBJECT_DEFINITION(a.object_id) <> OBJECT_DEFINITION(b.object_id)
