Execution plan of a stored procedure containing dynamic sql is reused?

See more:

SQL-Server

T-SQL

Hi,

I have a sp which has no input parameters .I also have dynamic sql statemtns build and executed usign sp_executesql.My question is when we execute the sp more than once ..will the execution plan that is generated for the first time is reused or not?
Here is the code block:

CREATE proc uspcachehitchk
as
begin
DECLARE @sal bigint;
DECLARE @SQLString nvarchar(500);
DECLARE @ParmDefinition nvarchar(500);
declare @dbsortorder varchar(100)
set @dbsortorder='desc'
declare @cols nvarchar(1000)
set @cols=N'empno,ename,job,mgr,SAL'
declare @size int
set @size=4
SET @SQLString =
   N'select top(@size) '+ @cols + ' from emp where sal>Convert(varchar(100),@sal) order by ename '+ @dbsortorder;
SET @ParmDefinition = N'@sal bigint,@cols nvarchar(100),@size int';
SET @sal= 2000;
EXECUTE sp_executesql @SQLString, @ParmDefinition,
           @sal= @sal,@cols=@cols,@size=@size;
           end

I have used SP:cachehit and SP:cachemiss events in the profiler to trace ..but i could only see the select statement is firing sP:cachehit..but not the sp.IS this the correct way to check for execution plan reuse..or if there exists any other please help me .

Regards
Chaithanya M