home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,128 of 19,505   
   Bob Barrows to omtechguy   
   Re: NOLOCK Declaration - one time for al   
   22 Feb 11 12:48:48   
   
   9e100b27   
   From: reb01501@NOyahooSPAM.com   
      
   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?   
   >   
   Really? You think this might be a good idea? I don't think it is possible   
   per se, but you should probably investigate using snapshot isolation if   
   using SQL 2005 or later.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca