|
|
Posted by Jerry Hewett on 07/25/06 21:53
Is there anything I can do from the Enterprise Manager console or from
within a JDBC connection to achieve the same effect as WITH(UPDLOCK)?
Yes, I could change all of my SQL statements to include the lock... but
isn't there any way to set or tweak something in SQL Server so that I won't
have to hack a lot of code* to make things concurrent? Perhaps a way to set
UPDLOCK as the default behaviour for the server, or schema, or table, or
something?
Jerry H.
* == The existing SQL has to remain as generic as possible so that it can be
implemented for four other databases.
Navigation:
[Reply to this message]
|