RE: sp_prepexec procedure problems
sp_prepexec does two things 1. Prepares the Stored procedure execution plan 2. Executes the stored procedure Now the first step usually takes some time depending on the complexity of stored procedure and WITH RECOMPILE option set/not set etc.. Are you saying that sp_prepexec is appearing repeately and frequently for the same stored procedure? Then this […]
2003-08-07