remenard
asked on
Can a SQL connection have more than one spid?
Hi,
We are having some connection problems with SQL server 2008.
SQL gets an error and creates a mini dump when we run the program.
One curious question is can a connection only have one spid at a time?
Or can it have multiple and how does it relate to the connection pool.
The other thing is they have been changing the database status from multi user mode to single user and then it is changed back to multiple user.
Were thinking something is happening when it changes between single and multi user mode and the connections in the pool and the active connection.
We are having some connection problems with SQL server 2008.
SQL gets an error and creates a mini dump when we run the program.
One curious question is can a connection only have one spid at a time?
Or can it have multiple and how does it relate to the connection pool.
The other thing is they have been changing the database status from multi user mode to single user and then it is changed back to multiple user.
Were thinking something is happening when it changes between single and multi user mode and the connections in the pool and the active connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The error we are getting we trap is after it tried to set the database to multi user mode.
Setting Database to Multi User Mode.
Failed to connect to server .
The error does not seem to trap more information, sorry to say,
checked SQL server logs nothing and checked event logs nothing there either.
The application is C# using Dot Net SQL libraries and our own.
Wish I had more information but all I have at the moment.
Setting Database to Multi User Mode.
Failed to connect to server .
The error does not seem to trap more information, sorry to say,
checked SQL server logs nothing and checked event logs nothing there either.
The application is C# using Dot Net SQL libraries and our own.
Wish I had more information but all I have at the moment.
ASKER
The other two things I found out is that they have added the service broker to the database.
The database could also have replication running as well in some cases.
I would guess this would make the connections issue more complex.
Would it be better to go through and kill each spid by it self and then change from multi user to single user?
Not sure that would help clear out the connetions better thatn via the database mode change.
Thanks.
The database could also have replication running as well in some cases.
I would guess this would make the connections issue more complex.
Would it be better to go through and kill each spid by it self and then change from multi user to single user?
Not sure that would help clear out the connetions better thatn via the database mode change.
Thanks.
I'm sorry - this slipped off my radar. Do you still need assistance?
ASKER
Sorry, we been swamped, looks like it was connection that was created in an application and then passed to another module when it should not of been.
Thanks for you help.
Thanks for you help.
What is the error that SQL is returning?