Try

EXEC sp_create_translator '01/01/2002'

>Hello group,
>
>I have a procedure:
>
>CREATE PROCEDURE sp_create_translator
>@SchoolYear smalldatetime
>AS
>How do I exec this from the sql server query analyzer. Exec '01/01/2002' doesn't work or {01/01/2002 }either.
>
>Thanks
>Jim