Calling a stored procedure multiple times

This is probably an easy question but when I call a stored procedure
from my website multiple times sometimes it return data and sometimes
it does not. The stored procedure just contains a select statement in
it. Could it be that I'm locking the table and it cannot access it? I
believe it a keyword that you can used to not lock a table. Can
someone tell me? Is this the right solution? Thanks!You could use (NOLOCK) Hint. But this does a dirty reads on the table.
Thanks
hari
"BillGatesFan" wrote:
> This is probably an easy question but when I call a stored procedure
> from my website multiple times sometimes it return data and sometimes
> it does not. The stored procedure just contains a select statement in
> it. Could it be that I'm locking the table and it cannot access it? I
> believe it a keyword that you can used to not lock a table. Can
> someone tell me? Is this the right solution? Thanks!
>|||Thanks! That's it.