I find default parameters very useful as I work in an environment where I often have an Access application sharing an SPROC with a web page where a parameter might be needed for the web page but is always the same coming from the application.
Patrick Edgerton
DBA Resource Concepts