Mahesh Bote (2/2/2009)
[font="Verdana"]Parameters in SProcs are not optional. You have to mentioend them while calling the SProc. You can instead mention 'DEFAULT' keyword while passing the parameters. Like:
EXEC dbo.sp_Sample Default, DefaultMahesh[/font]
If you use default values for your parameters you don't have to mention them. A good example is sp_send_dbmail which has about 20 parameters, but most of the time I supply only 2 or 3.
[font="Verdana"]Markus Bohse[/font]