• sjimmo (12/2/2010)


    Once again, since there is not a field for comments about the object, how can you say that comments are returned? The truth of the matter is that the definition of the object is returned, which may or may not contain comments internal to it.

    But you had to qualify the word "comments" in your own reply! There ARE comments within the definition of the stored procedure, and they DO count! Many languages, when they compile the code, strip out comments as wasted space. I could easily see a scenario where the definition of the SP, in order to save space, strips out the comments from the definition in order to maximize the system table space. You have defined comments as "an explanatory column about the object that is separate from the object itself" and most of us did it as "explanations within the object that tell you what it does". Just the fact that we have to have this discussion at all proves how poorly written the question was, if no one can agree upon what is meant by "comments" and from two separate interpretations both views could be correct.

    Also, FWIW, within the batch of a stored procedure creation, comments before the definition actually begins are also included within the column Text, so by a certain definition those are not "within the definition of the object" since the CREATE PROC command has not come yet, and yet comments exist.

    In order for these questions to have value, we really need them to have clarity and no ambiguity.