Could not find stored procedure 'proc_ECM_RetrieveTableNames' Error

Got this error while creating Managed Metadata Service Application

Cause : Error occurs when we create  managed metadata service with a  pre-existing database (even a blank database) in SQL.

Solution : We need to recreate the managed metadata service application with a new database name.

Reference :  http://sharepointsniper.wordpress.com/2011/03/14/error-could-not-find-stored-procedure-proc_ecm_retrievetablenames-while-creating-managed-metadata-service-application/