I am calling a stored procedure from PERL with a timeout set to big
number. The script runs 8 stored procedures and writes the output to
HTML format. These stored procedures are complex nested stored
procedures.  The script runs fine first time . If I try to run the
script with new data in tables it hangs.  If I restsart the SQL server
and then run the script it works fine, but second time onwards it again
times out.  I am using win32::ole and ADO to connect to sql server.

NOTE: If I run the store procedure from T-SQL it works fine even while
      the script is{*filter*}.

Thanks in advance

Alvito.