Thanks for the suggestions.

I think I may have finally figured it out. When I checked the log file settings I noticed that autogrowth was set to a limit of 2...

Thanks for the quick response.

Yes, thats part of the problem.

On the application side I just get a timeout error and on the SQL side I don't get anything. It appears...

I'm calling the stored procedures directly.

Thanks for responding.

Its an interesting solution. The problem I am working on currently will collect data nightly from several clients and produce and email reports programatically on a daily basis...

something like;

Select Top(2) XXXXXX from (Select 4 XXXXX from YYYYY order by XXXX Desc)

try using pivot