9e100b27   
   From: sorrytoomuchspamalready@xs4all.nl   
      
   omtechguy wrote:   
   >   
   > Is there an option to declare one time at the beginning of the SP that   
   > all the selects will run with NOLOCK command instead of writing if   
   > after each table name?   
   >   
   > Thanks.   
      
   Well, you can SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the   
   beginning of the SP. That will apply this transaction isolation level   
   wherever possible during the scope of the SP.   
      
   Please note that you should only do this if you are sure that there are   
   no data modifications done on those tables during your transactions.   
   --   
   Gert-Jan   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)