I'm looking for a way to properly comment my stored procedure code so that I can extract the information into useful documentation ala something like XDOC (or C# equivalent). Something that's preferably lightweight would be ideal.
If you're already using Sandcastle to generate documentation based on the XML comments that Visual Studio generates, you might want to check out the following CodeProject project:
It shows you how you can use the tools you're already using to generate documentation for your SQL objects in the same style as the documentation you're already generating for the rest of your code.