In job SAP BOBJ 4.2 - Initial Load, in SQL queries
fx_bobj_load_user_to_group.sql
fx_bobj_load_group_to_group_privs.sql
some of the virtual tables created from subqueries have WITH NOLOCK immediately after their alias, others don't.
Check the MS documentation whether WITH NOLOCK makes sense in this case - probably it doesn't. If yes, use it consistently everywhere. Otherwise, remove all unneeded occurences.
In job SAP BOBJ 4.2 - Initial Load, in SQL queries
some of the virtual tables created from subqueries have WITH NOLOCK immediately after their alias, others don't.
Check the MS documentation whether WITH NOLOCK makes sense in this case - probably it doesn't. If yes, use it consistently everywhere. Otherwise, remove all unneeded occurences.