Toad World® Forums

SP viewer


#1

Hi all,

Toad hangs when I click on the script tab on a viewer for a stored procedure.

Ercan


#2

Hi Ercan,

This is not the truth J I mean not the truth for all SPs. Can you please provide
any additional info? Server version, SP script (you can generate it from other
places, right?)

regards,

Alexander Maximov
image001.jpeg


#3

Ok, I cannot regenerate it anymore. It doesn’t hang, but it takes very long
till I get the script. And apparently the time it takes depends on how long the
script is. An SP with 10 lines opens in a couple of seconds, but an SP with 700
lines takes > 20 secs.

On Wed, Feb 9, 2011 at 3:02 PM, Alexander Maximov

wrote:

Hi Ercan,

This is not the truth J I mean not the truth for all SPs. Can you please
provide any additional info? Server version, SP script (you can generate it
from other places, right?)



regards,

Alexander Maximov

image001.jpeg


#4

Hi Ercan,

Looks really strange. How is the TSS behavior on your server in general? I mean
connect time to this server, open new Editor Window, switch between viewer tabs
etc.?

Can you please share with me creation script for that SP (700 lines)? All that
you have on Script tab would be very appreciated.

regards,

Alexander Maximov
image001.jpeg