Home Forums SQL Server 7,2000 T-SQL alternative to nolock to avoid blocking trans RE: alternative to nolock to avoid blocking trans

  • Most of it is generated in stored procedures. I want to honor other locks that are on the data. But, while those locks from other procs are in place, I want to be able to read the data and be sure not to issue locks...except perhaps on schema. I don't want to issue any new locks on the data with these reporting procedures.