dbs/mss/update_with_updlock - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

------------------------------------------------------------------------
| Parameter: dbs/mss/update_with_updlock                               |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short description: MSSQL: Set UPDLOCK hint on all UPDATE SQL statem  |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter description:                                               |
| ----------------------                                               |
| When this parameter is turned off, SQL UPDATE statements will no     |
| longer contain an added hint: UPDLOCK HOLDLOCK.  This hint has been  |
| used for years in MS SQL Server to avoid deadlocks mainly in the     |
| spool area (TSP tables).  The hint does reduce concurrency, so if    |
| no deadlocks are observed without this flag, it can be turned off to |
| gain some performance through increased concurrency.                 |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Application area: Database                                           |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Unit: 0/1                                                            |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Default value: 1                                                     |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Person(s) allowed to make changes:                                   |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for the operating systems:                               |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for database systems:                                    |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Are other parameters affected or dependent:                          |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid entries, formats, areas:                                       |
------------------------------------------------------------------------


------------------------------------------------------------------------ 
| Short Description : MSSQL: Set UPDLOCK hint on all UPDATE SQL statements 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Applications Area : Database 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Parameter Type : S 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Changes allowed : W 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Valid for Operating System : * 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Dynamic switchable : X 
------------------------------------------------------------------------ 

------------------------------------------------------------------------ 
| Same on all Servers :  
------------------------------------------------------------------------ 

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.


Length: 4465 Date: 20120525 Time: 164111     triton ( 6 ms )