I'm using the nolock hint in a stored procedure. I alter the procedure in sql editor and it complies. However, the next time I view the procedure, nolock is not displayed. If I look at the procedure in SSMS, the nolock exists and is displayed. What can I do to display the nolock hint in sql editor.
dbForge 3.0.136
Sql Server 2008
NoLock doesn't display in SQL editor
-
alexa
Re: NoLock doesn't display in SQL editor
Unfortunately, we were not able to reproduce such problems on our test environment.
Could you please provide us the CREATE statement of your procedure?
You can send the reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via that system.
Could you please provide us the CREATE statement of your procedure?
You can send the reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via that system.