I have the normal events for Stored Procedures and TSQL checked which normally works with other querys I send from my web pages.
But when I look at the profiler after running the report I get the parameters but no values:
This is what I copied from my profiler window - notice parameters but not what they are equal to:
proc_RptProducerBook @ProfitCenter, @HireDate, @UserID, @Permission, @IncludeRetail,@IncludeWholesale,@IncludePrograms, @IncludePersonalLines
Why is this and is there a way to get the profiler to show the data?
Thanks,
Tom
But when I look at the profiler after running the report I get the parameters but no values:
This is what I copied from my profiler window - notice parameters but not what they are equal to:
proc_RptProducerBook @ProfitCenter, @HireDate, @UserID, @Permission, @IncludeRetail,@IncludeWholesale,@IncludePrograms, @IncludePersonalLines
Why is this and is there a way to get the profiler to show the data?
Thanks,
Tom