In development server it takes less than 1 min. but in Testing server it takes more than 10 mins and in testing server we don't have permission to use...

The scenario is there is a thread that works in the background in vb.net code which calls a stored procedure which does the insert.

Earlier it use to take 1 min....

Sorry Shaw,

To post on the other thread.

I have used management studio to insert into the table and it inserts.

There is abackground thread running in my .net code which call the...

Thanx Shaw,

The permission is there and insertion happens but not able to know wether is it the table is locked or there is any connection problem.

Hi Shaw,

The prob here is I execute the script , it gives me this error and the stack trace says me this.

and then the insert happens after 10 or 15...