You can't actually make them mandatory, but you can add something like:
create proc MyProc
(@MyParam1_in datatype)
as
if @MyParam1_in is null
raiserror('Null values not allowed for MyParam1_in', 16, 1)
...the rest of the proc...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon