Another Issue:

1. I created a connection
2. Set transaction to manual
3. Process my transaction using Stored Procedures
4. After processing the first transaction i paused the program and then attempted to run a select on the first table that the transaction affected(add a new record). The select took quite a bit of time to run and eventually timed out. I did this to see what would happen when users are all doing the same thing at the same time.
5. On another ocasion I let the program run and all subsequent transactions took forever.

Any suggestions ??