• ya i have did that. but its strange that i cant see the comments as wanted earlier.

    if use 2005 SSMS to modify the sp i cant the comments. where as if use 2008 ssms i can see comments its very strange