• Thanks for the good advice.

    I should have done more research before asking the question.

    Upon my request for information the developer gave me the connection string and it was the wrong server and database. I'm standing by to assist him as needed.

    I monitor the server for issues constantly and I occasionally see processes that he is running but no issues so far.

    My tail is behind my legs. :blush:

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/