If a stored procedure is modified 10 times , i want to log or track it in a table in a column in 10 rows from initial stored procedure to the latest that is 10 different versions of the same stored procedure , could any one suggest how to do this?
You don't say which version of SQL server you're using, but have you looked at DDL triggers?
I know I'm not directly answering your question, but did you consider using a source control tool for it? Like svn, source safe, ...
In case you are using dot net it will be a good idea to create a Database project where you can store the SP as well as scripts for all other objects and use some source control where you will be able to maintain version history.