>Before calling a StoreProcedure is there any way to know how many parameters are required ?
Quick google search brings this
http://support.microsoft.com/kb/165156I didn't have time to search more thoroughly.
If it's not broken, fix it until it is.
My Blog