Why are some comments removed from stored procedures in SQL Server 2005?

[Ron Savage]

I use a lot of comments in my stored procedures to document my code for future developers that might have to modify / debug it. However, when I view my stored procedure script or pick the "modify" option in SQL Server Management Studio the code comes up with blank lines where my comments are supposed to be. I see other stored procedures that have retained thier comments (although they are much smaller in size) using the same "--" single line comment that I use. Anyone know why that is happening? Thanks,

Ron

[Ron Savage]

Nevermind, I figured it out. The query tool I am using ( WinSQL - very handy tool ) has an option to "Parse Comments Locally" which was turned on - so it was removing the comments *before* sending the to SQL Server to save. :-)

Ron