Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance - my SP needs some
Message
From
27/09/2002 18:27:33
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00705044
Message ID:
00705475
Views:
9
>>>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
Map
View

Click here to load this message in the networking platform