are you Using this line, if not use

cmd.CommandType = CommandType.StoredProcedure;

using Stored Procedure in c#
using Stored procedure in VB.Net