release a lock from table that occured while running a stored procedure

[vikasavinash]

Hi All,

I would like to know how to release a lock from table that occured while running a stored procedure.

Thanks :)

[Rabbit]

It should release automatically after the code is run. But if it's not, then you need to show us the code. We can't help if we don't know what you're doing.

[ck9663]

If you're stored proc is just reading the table, a NOLOCK hint should be fine. However, you should be careful as you might be accessing stale data.

~~ CK