General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>>>Can you provide an execution plan?
>>>
>>
>>I'd like to but I'm not sure how... I ran the SP in hte Query Analyzer wirh Execution Plan set on, however I do not see a way to grab the results and set them over.
>>
>>Please advise....
>
>check out SET SHOWPLAN_TEXT in the BOL.
OK...
So in the Query Analyzer I entered SET SHOWPLAN_TEXT ON
This was the result:
StmtText
------------------------------
SET STATISTICS PROFILE ON
(1 row(s) affected)
Server: Msg 208, Level 16, State 1, Line 16
Invalid object name '#temp'.
StmtText
-----------------------------
SET STATISTICS PROFILE OFF
(1 row(s) affected)
However with SET SHOWPLAN_TEXT OFF I do not get any errors...
Any ideas????
Thanks,
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only