Just another related thought...

While I totally agree that commenting code is a good thing, I've gotten out of the habit of using the /* method except for at the beginning of a procedure.

Slashes in the middle of a procedure can prohibit you from commenting out a large chunk of a procedure when debugging.

For example - let's say you have a 200 line procedure and something isn't working properly. You realize that commenting out lines 170 through 220 can help pinpoint the problem. The easiest way to do this is to block out those lines by using the /* */ method - but if there are OTHER comments already using that method inside that chunk of code, you have to first replace those with hyphens (pain!!)

I'm waiting for the day when it's possible to debug SQL Server procedures as easily as one can vb code...