Sql Timeout Error

[ayuba asia]

I have a case which i run the sql statement from my c# application.. becasue the query is big and dont have indexed on the table sometimes i got the timeout error how so i set the timeout period.. i cannot change the database structure cause is it in use and they dont do want to make any changes to it.. any sugesstion..

[rmhewa]

Try this. Set the 'CommandTimeOut' of the Connection and the SQLCommand object you r using to execute the sql to 0 (Zero) Rohitha M.Hewa Senior IT Executive Naturub Group of Companies - Sri Lanka

[Colin Angus Mackay]

That is dangerous because the application will block until SQL Server returns the answer. You should always put an acceptable upper limit so that control will eventually return to the application.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius