When I run sp_who2 on my sql server 2005, I got several processes "suspended" in a user database. I do not know what it means exactly and how to deal with it. What I can see is that,
1. This is not good.
2. Once a process is suspended, it stays suspended until the front-end Access database is close.
3. A suspended process blocks another process, which in my case the front-end Access cannot insert a record.
Could someone explain to me what is "Suspended", how to deal with it, or maybe more important, how to avoid it?
Thanks in advance.
Seaport
1. This is not good.
2. Once a process is suspended, it stays suspended until the front-end Access database is close.
3. A suspended process blocks another process, which in my case the front-end Access cannot insert a record.
Could someone explain to me what is "Suspended", how to deal with it, or maybe more important, how to avoid it?
Thanks in advance.
Seaport