I'm getting some wierd behavior on executing a sproc that does an insert.

I do this in Page_Load to track sessions.

I run a sproc that inserts a record with ExecuteQuery on a SqlCommand object.

 After repeated execution of the method that calls the sproc, the table appears to get locked for that record (using a different id with the same sproc appears to run fine).

 Execution of the insert sproc takes longer and longer until it times out.

Should I be adding any special parameters to my SqlCommand or SqlConnection objects to prevent this behavior?

check using sql profiler

Hi John,

Are you using Transaction with your SqlCommand or in your stored procedure? This situation generally occurs for the transactions that are neither committed nor rolled back.