How to run extremely long stored proc on SQL server in c#?

[huckfinn19]

Hi all,

I need to have a thread that runs a stored procedure that can take up to an hour to process. This task is going to be scheduled to run at night on a DB server and the code that runs it has to be C#.

The stored proc runs fine when executed in the query analyser, but I get timeouts when I try to run it from the code.

How can I achieve this while making sure there is never any timeouts?

I am using .Net framework 1.1 and SQL Server 2000

Thanks!

Huck

 

[stsuing]

set the CommandTimeout property of the command object to 0