• So if you execute the sp in a query window it will be

    EXEC spName Parm1, Parm2, Parm3

    but since you are not providing parm 2 or 3 you are essentially using

    EXEC spName Parm1

    Does this work in a query window?