sys.objects [name] column is not consistent with object name in definition (stored procedure name)
Last week, as a part of one requirement, I wrote a script to generate object definition for all database objects. While testing, I found that for few stored procedures, [sys.objects].name was not matching with name in actual object definition (as returned by OBJECT_DEFINITION(Object_ID)). It was very strange and I saw it first time in life. While thinking for what could be the reason of same, I found that it happens when we rename stored procedure from Object Explorer (View--> Object Explorer in SQL Server Management studio). Just wondering, is there any way to retrieve actual object name (in this case, SP name)?