Try this
ALTER PROCEDURE [dbo].[GetUserId]
@Name VarChar(200)
AS
BEGIN
SET NOCOUNT ON;
SELECT *
from dbo.Users
where ADName like @Name
SET NOCOUNT OFF;
END
I guess your name parameter expects some length values to be defined. and additionally do your name is exactly same as stored in column or you need likely names, then you have to use the wild card(e.g %).