Friday, February 24, 2012

Delete statement times out and blocks reads

Hi. Periodically I need to run a delete statement that deletes old data. The problem is that this can timeout using ODBC (via the CDatabase and CRecordSet classes in legacy code). Also, while its running the delete, the table its operating on is locked and my application can't continue to run and operate on rows not affected by the delete.

Are there any workarounds for this? Can the timeout be set in the connect string?

Thanks,

Brian

No, you will have to set the timeout value on the appropiate command object.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment