Execution plan for stored procedures w multiple statements

I read somewhere that SQL Server 2000 as of service pack
3, creates a separate execution plan for each sql
statement in a stored procedure so if the execution plan
for one statement needs to be recompiled only that
statement gets recompiled and not the entire stored
procedure. This way you don't have to create a wrapper
stored procedure that calls individual stored procedures
with a single sql statement in them. Now I can't find this
article. Could someone please shed some light on this
issue. Thanks.
ChrisChris,
Someone has been lying to you. SQL2K does not have statement level recompile
..
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Christian Mark Jensen" <anonymous@.discussions.microsoft.com> wrote in messa
ge
news:243ce01c45f52$817e1fa0$a401280a@.phx
.gbl...
> I read somewhere that SQL Server 2000 as of service pack
> 3, creates a separate execution plan for each sql
> statement in a stored procedure so if the execution plan
> for one statement needs to be recompiled only that
> statement gets recompiled and not the entire stored
> procedure. This way you don't have to create a wrapper
> stored procedure that calls individual stored procedures
> with a single sql statement in them. Now I can't find this
> article. Could someone please shed some light on this
> issue. Thanks.
> Chris
>