• If the stored procedure does not connect to another server then it's very unlikely network problems would affect the performance.

    Assume the stored procedure only accesses databases on this server, what else could have changed?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]