How does a stored procedure takes 15 seconds to start?

  • Well, I managed to see it, so you should be able too.

    Just look at the right places - system objects in databases where user objects are created/modified.

    Since you say you use a lot of temp tables - look at tempdb first.

    _____________
    Code for TallyGenerator

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply