Hi, you have created a temporary stored procedure, and it's scope is limted to that session/window. try removing the
# from the stored procedure name.
create proc Show(@Value int, @EmpName varchar(50))
WITH ENCRYPTION
as
(
select * from EmpDetails where (ImpId = @Value or @Value='') and (EmpName=@EmpName or @EmpName='')
)