When using e-mail it will occasionally lock up. Is there an answer
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
When it locks up, repeatedly using the left mouse button with the cursor on
the file word, will eventually break it loose. The left mouse button has to
be hit at least fifteen or twenty times.
.
Relevant Pages
- Re: Opinions on approach, please...
... applications that INTENTIONALLY used "locks" to ... records to serialize processing. ... non-issue with the types of applications that you would want to convert. ... The data for the cursor is fetched into an internal result set at the time ...
(comp.lang.cobol) - Re: After SP4, proc w. Cursor doesnt release keylocks
... May Hold Locks Longer http://support.microsoft.com/kb/260652/ ... As a shot in the dark, if the cursor declaration just says: ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver) - Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
... With a cursor, ... I would use update locks in the set-based solution too--reduces the ... generation of the execution plan, and if you compare execution plans, you'll ... objects is smaller than with the solution with multiple self-joins. ...
(comp.databases.theory) - Re: Large Table Deletes
... you fragment a table using the "with rowids" clause, ... although lock allocation is dynamic, ... locks. ... prepare delete cursor with hold ...
(comp.databases.informix) - Re: FOR UPDATE cannot be specified on a READ ONLY cursor
... wanting to perform updates via a SQL Server server cursor using T-SQL: ... a normal SELECT can hold locks if you are using ... SERIALIZABLE transaction isolation level in SQL Server (as Joe eluded to ...
(microsoft.public.sqlserver.jdbcdriver) |
|
