You should check what type of locking procedure you are using; and by the time you want to view the data on your table; try to make use of NOLOCK...

Actually Gila, I do it because I have multiple instance of application which calls this stored procedure, the duty of this SP is to get new request from my inbox...

Thanks guys! My situation is this; I have source table from a server which is my Inbox.tbl and I have multiple instance of application that continuously reading this table ex:

DECLARE...