Robust Plan execution error?

I am running a select against a View that exceeds the max allowable row size and added OPTION (ROBUST PLAN) to the select to enable the select to return a result when the row size is a problem. The original view does a number of joins.

One of our users has reported that some data values they expect to see in some of the columns for specific rows are missing or incorrect. Could using the ROBUST PLAN hint cause this to occur?

Thanks,

ChrisRefer to this link (http://www.sql-server-performance.com/hints_query.asp) for tips on ROBUST PLAN and SQLMAG (http://www.sqlmag.com/forums/messageview.cfm?catid=9&threadid=15767) link for references.

Reusing Execution Plan

I've created a stored procedure and tried to compare the
execution plans by passing different parameters to it. The
execution plan in all the cases is displayed as same. But
how can i make sure that SQL Server is using the same
execution plan from memory each time i execute my stored
procedure. I want to make sure its not recreating the
execution plan each time i call the stored procedure.
Appreciate if anyone can help me to trace that.
Lots of thanks in advance.Look at masters syscacheobjects for your proc
select * from master.syscacheobjects where objid = object_id('myproc')
If you are plan sharing, you should see 2 entries, 1 executable plan and
1compiled plan...
"Sudhakar Koolla" <anonymous@.discussions.microsoft.com> wrote in message
news:093801c3b81d$492771b0$a301280a@.phx.gbl...
> I've created a stored procedure and tried to compare the
> execution plans by passing different parameters to it. The
> execution plan in all the cases is displayed as same. But
> how can i make sure that SQL Server is using the same
> execution plan from memory each time i execute my stored
> procedure. I want to make sure its not recreating the
> execution plan each time i call the stored procedure.
> Appreciate if anyone can help me to trace that.
> Lots of thanks in advance.

Reusing Execution Plan

I've created a stored procedure and tried to compare the execution plans by passing different parameters to it. The execution plan in all the cases is displayed as same. But how can i make sure that SQL Server is using the same execution plan from memory each time i execute my stored procedure. I want to make sure its not recreating the execution plan each time i call the stored procedure
Appreciate if anyone can help me to trace that
Lots of thanks in advance.See my other reply. Please don't multipost.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Sudhakar Koolla" <sudhakar.koolla@.wipro.com> wrote in message
news:465AB931-50FE-4F2D-9A7F-143A69B7CEE5@.microsoft.com...
> I've created a stored procedure and tried to compare the execution plans by passing different
parameters to it. The execution plan in all the cases is displayed as same. But how can i make sure
that SQL Server is using the same execution plan from memory each time i execute my stored
procedure. I want to make sure its not recreating the execution plan each time i call the stored
procedure.
> Appreciate if anyone can help me to trace that.
> Lots of thanks in advance.