How to prevent timeout from long running sqlclr procedure which may run a long time

Question

How to prevent timeout from long running sqlclr procedure which may run a long time? The procedure sometimes will need  to copy a lot of files to/from some slow devices and could take as much as an hour. I have not tried this and so I don't know if it is really a problem, but it I suspect there would be problems.

Answer 1

Hi mwindham,

To avoid timeout issue when the CLR stored procedure connects to SQL Server, you can increase the CommandTimeout property. If the timeout is about the SQL CLR project itself, you may consider to configure the properties as this blog: Timeout when deploying SQL CLR objects from Visual Studio 2005 or 2008 but not from Management Studio.

---

Stephanie Lv

TechNet Community Support